Forum Discussion
eryka_90
Helper I
Helper ITotal Cumulative - Date Hierarchy
Hi, I'm having an issue when to visualize Total cumulative in Metrix table or chart. The total cumulative showing right value when I'm not using date hierarchy (Document Date) but when it's chang...
Hi,
Try this approach
- Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number
- Create a relationship (Many to One and Single) from the Date column of the Fact Table to the Date column of the calendar Table
- To your visual, drag Date from the Calendar Table
- Write this measure
Measure = calculate([#total amount],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))
Hope this helps.
Ashish_Mathur
Super User
Super UserHi,
Try this approach
- Create a Calendar Table with calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number
- Create a relationship (Many to One and Single) from the Date column of the Fact Table to the Date column of the calendar Table
- To your visual, drag Date from the Calendar Table
- Write this measure
Measure = calculate([#total amount],datesbetween(calendar[date],minx(all(calendar),calendar[date]),max(calendar[date])))
Hope this helps.
eryka_90- Ashish_Mathur
You are welcome.