Cumulative not working

[Antmkjr]

https://drive.google.com/file/d/1W9M2bYEZyrreuUsSpVU9D3I1tr1ogIk3/view?usp=sharing

Im trying to get the cumulative of Funding, But not able to, can anyone help? Expected result is shown, also when drilled up to yearly level it should work fine.

Expected:

Thanks in advance

[jameszhang0805]

[amitchandak]

@Antmkjr , if you do not have a date column, Create one like

date = "01 " & [Month Name] & " " & [year] // change data type to date

Then try a measure like

Cumm Sales = CALCULATE(SUM(Table[Funding]),filter(allselected(Funding),Funding[Date] <=max(Funding[Date])))

[Antmkjr]

Ideally that should work, I have tried this

CALCULATE (

SUM([Funding]),

FILTER ( ALLSELECTED( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )

)

But is not working...