Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Cumulative sales with multiple years

Hi, the line graph above is exactly what I need. This is the code for the graph: Cumulative = CALCULATE(SUM('INS_Booking'[USDN3]),FILTER(ALLSELECTED('INS_Booking'),'INS_Booking'[date_]<=MAX('I...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Frank,

Unfortunately, we're pretty strict about sending stuff and it's mostly confidential. I've been told to hold off. Do you think theres a way we can take a swing at it without the dataset?

Basically I just need cumulation measures that can be put on the same graph/table and can be compared by week number. So that I can compare 2017 cumulation with 2018 and 2019.

The problem is that for the measure wants to look at MAX date (today) and get the cumulative total rather than the max date in the year specified in the measure. IDK if any of this makes sense haha here's a graph with 2017 nuimbers too.



It's just repeating the total because it's looking at the max date (today) and for 2017 it returns it's cumulation but I want it to return the cumulation as if I were inputting same period last year.

2017 Cumulative = CALCULATE([Book2017],FILTER(ALLSELECTED('INS_Booking'),'INS_Booking'[date_]<=(MAX('INS_Booking'[date_]))))
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
7 years ago

Hi Anonymous ,

 

Please try to use this formula.

 

2017 Cumulative = var maxdate = CALCULATE(MAX('INS_Booking'[date_]),ALLSELECTED('INS_Booking'))
return result= CALCULATE([Book2017],FILTER('INS_Booking','INS_Booking'[date_]<=maxdate))

Regards,

Frank