Forum Discussion

yasbos's avatar
yasbos
Resolver II
4 years ago
Solved

Cumulative Month Total YoY

Hello, Team. I've been struggling with this. I need to calculate the cumulative month total for the current year and for the previous year and present them on the same graph. My problem is that when ...
Need Help
  • ALLUREAN's avatar
    ALLUREAN
    4 years ago

    Hi, yasbos 

    Try this: 

    MaxDate=CALCULATE(max(Sales_Fact[Sale Date]), REMOVEFILTERS('Calendar'[Date]))

     

ALLUREAN's avatar
ALLUREAN
Solution Sage
4 years ago

Hi, yasbos 

Try this: 

MaxDate=CALCULATE(max(Sales_Fact[Sale Date]), REMOVEFILTERS('Calendar'[Date]))

 

yasbos's avatar
yasbos
Resolver II
4 years ago

OMG, ALLUREAN ! That worked. I have NO IDEA what just happened, though. Thanks so much. Thanks to ribisht17 , too, for responding.