Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Rollup

How to find roll up of the total outstanding of each month.
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 

    Does your "Roll UP" mean that you want to get cumulative sum result by month?

    You can try my way. Firstly build a date table by dax code.

    Date = ADDCOLUMNS(CALENDARAUTO(),"Year",YEAR([Date]),"Month",MONTH([Date]),"YearMonth",YEAR([Date])*100+MONTH([Date]))

    Build a relationshio between date table and your fact table by date column.

    Then build a measure.

    Roll UP = CALCULATE(SUM('Table'[Value]),FILTER(ALL('Date'),'Date'[YearMonth]<=MAX('Date'[YearMonth]))) 

    Result is as below.

    Best Regards,
    Rico Zhou

     

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