Forum Discussion
Solved
cummulative sum not working
Hi, Could someone help me on Cummulative sum? I have no idea why it is not working. I have two tables: Actuals and DimDate (relation one to many) In the dashboard I have selector DimDate( Year, Mo...
That's actually simpler DAX code, you can use the DATESYTD function
Cumm Sum USD = CALCULATE ( SUM ( 'Actuals'[Actual USD] ), DATESYTD ( 'DimDate'[Date] ) )
thank you very much for help! DATEYTD works as I expected .