I’m trying to calculate cumulative sales and compare it to cumulative sales last quarter. My cumulative sales measure is working, however when I plug that measure into the cumulative sales LQ, and use date add to change the context to last quarter, it is not adding up properly.
Here is my cumulative sales measure:
Cumulative Sales = CALCULATE([Total Sales],
‘Date’[Date] <= MAX(‘Date’[Date]) ) )
Here is my cumulative sales last quarter measure:
Cumulative Sales LQ = CALCULATE([Cumulative Sales],
DATEADD(‘Date’[Date], -1, QUARTER) )
Here is a snapshot of how these measures are displaying on a table:
My cumulative sales LQ measure is simply spitting out total sales from last quarter, but it is not taking a cumulative total. I’m not sure why this is happening, since I’m measure branching with the working cumulative sales measure.
Thanks for your help!