Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Cumulative total for my data model

Hello please help me to calculate cumulative based on this data model. In my data model there is no date sorting and most of the solutions on the internet are based on this.  in my data model index ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

     

    Please refer the formula.

    Measure = CALCULATE(SUM('Table'[value]),FILTER(ALLSELECTED('Table'),'Table'[index]<=MAX('Table'[index])))

    Result would be shown as below.

     

    Best Regards,

    Jay

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

Anonymous , Try

Create a new column

Date = "01-" & [Month] & "-" [year] //Change data type to date

 

and then measure

Cumm ACTUAL+FORECAST = CALCULATE(SUM(Table[Value]),filter(allselected(Table),Table[date] <=max(Table[Date]) && Table[Type] = "ACTUAL+FORECAST"))

 

Cumm BUDGET = CALCULATE(SUM(Table[Value]),filter(allselected(Table),Table[date] <=max(Table[Date]) && Table[Type] = "BUDGET"))