Help with Cummulative data DAX query

Question

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_dim[Date])= 2021

)

But it's only showing me the total data for every month.

Could someone help me what I am doing wrong here?

amitchandak · Answer

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 
&nbsp;
Kum_AE_Combined_2021 = CALCULATE (SUM(AE_Weekly[AuftrEing]),FILTER (ALL(Date_dim[Date]), // or use allseleceted&nbsp; Date_dim[Date] &lt;= MAX (Date_dim[Date]) ))
&nbsp;
use datesytd for yearly
CALCULATE (SUM(AE_Weekly[AuftrEing]),datesytd('Date_dim'[Date]))

newbie9292 · Answer

newbie9292 · Answer

Hello!Thanks for your reply. It's not working. Still showing me the same values.

newbie9292 · Answer

The above is from the DAX Kum_AE_Combined_2021 = CALCULATE(SUM(AE_Weekly[AuftrEing]),datesytd('AE_Weekly'[Date]))&nbsp;I have date_dim table which is my calender table which is connected to the&nbsp;&nbsp;AE_Weekly[AuftrEing] table.&nbsp;

newbie9292 · Answer

This is my desired output&nbsp;

Forum Discussion

Help with Cummulative data DAX query

8 Replies

Related content

Cummulative YTD Totals By Month Error

cummulative sum not working

Help with a DAX YTD Cummulative Query

cummulative total of volume

Cummulative Count