Cummulative total working for date measure but not for month measure

[Anonymous]

I have made a measure for the cummulative total of another measure using the following DAX formula:

Cummulative:= CALCULATE([Measure],DATESYTD('Date'[Date])

This gives the following result for a visual using the 'Date'[Date] collumn as the x-axis:

But if I try with the 'Date'[Month] collumn instead, I get a simple sum for each month:

How do I get the cummulative total for each month to work the same as the date?

[Icey · Accepted solution]

Hi @Anonymous ,

Try to create your Measure like so:

Cummulative 2 =
CALCULATE (
    [Measure],
    FILTER (
        ALLSELECTED ( 'Date' ),
        [Date].[Year] = YEAR ( MAX ( [Date] ) )
            && [Date] <= MAX ( [Date] )
    )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

This solution worked straight out of the box! Thank you very much! Kudos to you.

[amitchandak]

@Anonymous 

Is the Date table is marked as a date table? This should work. Right click on date table you have an option

Refer step at: https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-1-Time-Intelligence-in/ba-p/922885