I need 3 measures that will give me the cumulative total for the current week, current month and current year.
I’ve got the standard cumulative total calculation to start off with :
Cumulative Sales =
CALCULATE( [Total Sales];
FILTER( ALL( Dates[Date] );
Dates[Date] <= MAX( Dates[Date] ) ))
My other key measure is Today’s date : Today Date = TODAY()
In my graph, I will only have the product name. For a product, I need to know the cumulative total for the current week, month and year in regards to today’s date.
This is where I am stuck. How can I integrate my measure “Today Date” into the standard cumulative total to calculate the Total Sales for each measure - ie current week, current month, current year?
I’m using the Date dimension provided in the course,
Thanks heaps in advance