Forum Discussion
eryka_90
Helper I
1 year agoTotal 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...
- 1 year ago
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.
eryka_90
Helper I
1 year agoAshish_Mathur
Super User
1 year agoYou are welcome.