Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Cumulative not working

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 whe...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , 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])))

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Ideally that should work, I have tried this

    CALCULATE (
    SUM([Funding]),
    FILTER ( ALLSELECTED( 'Date' ), 'Date'[Date] <= MAX ( 'Date'[Date] ) )
    )
    But is not working...