Forum Discussion
Help with Cummulative data DAX query
I want to show Cummulative data in my visual : Kum_AE_Combined_2021 = CALCULATE ( SUM(AE_Weekly[AuftrEing]), FILTER ( ALL(Date_dim[Date]), Date_dim[Date] <= MAX (Date_dim[Date]) && YEAR(Date_d...
The above is from the DAX
Kum_AE_Combined_2021 = CALCULATE(SUM(AE_Weekly[AuftrEing]),datesytd('AE_Weekly'[Date]))
I have date_dim table which is my calender table which is connected to the AE_Weekly[AuftrEing] table.
This is my desired output