Forum Discussion

guruvammal's avatar
guruvammal
Frequent Visitor
2 years ago

Cumlative

Hi Team 

 

I Need this

 hi , Need cumulative  Dax function - choose the max of the date cumulative function is working in before the data is add cumulative is coming correctly but i need choose max of date start the cumulative function starting in choose the date which dax i used  

Need Help
Tips and Tricks

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Use Time Intelligence and use functions like TOTALMTD, TOTALQTD or TOTALYTD as the measure 
    SalesYTD = CALCULATE( [TotalSales, TOTALYTD('Date'[DateKey]))