Forum Discussion
Rollup
- Anonymous4 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 ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.