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...
newbie9292 , In this case the month should come from date table in visual , make sure that is true
Not sure on need of filter 2021
Date_dim should be marked as date
Kum_AE_Combined_2021 = CALCULATE (
SUM(AE_Weekly[AuftrEing]),
FILTER (
ALL(Date_dim[Date]), // or use allseleceted
Date_dim[Date] <= MAX (Date_dim[Date])
)
)
use datesytd for yearly
CALCULATE (
SUM(AE_Weekly[AuftrEing]),datesytd('Date_dim'[Date]))
The query is now working partially. When I select the slicer individually it correctly shows the cummulated data. But when I select both years in the slicer it doesn't shows the 2020 cummulated data correctly.