Forum Discussion

yasbos's avatar
yasbos
Icon for Resolver II rankResolver 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
Icon for Solution Sage rankSolution Sage
4 years ago

Hi, yasbos 

Try this: 

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

 

yasbos's avatar
yasbos
Icon for Resolver II rankResolver 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.