Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Cumulative charts

Hi everyone, I am trying to build a monthly report which includes 5 charts. All in one page. The second page will be a cumulative one which will sum up each chart every month. For example:  I have...
Need Help
  • MFelix's avatar
    MFelix
    3 years ago

    Hi Anonymous ,

     

    For this you need to create a YTD measure in order to use on the second page, to achieve this you also need a calendar table so that the time intelligence calculation can be used.

     

    For example the metric would be something similar to:

    Sales Cumulative = 
                 TOTALYTD( 
                     SUM(Table[Sales],
                     DateTable[Date]
                 )
MFelix's avatar
MFelix
Super User
3 years ago

Hi Anonymous ,

 

For this you need to create a YTD measure in order to use on the second page, to achieve this you also need a calendar table so that the time intelligence calculation can be used.

 

For example the metric would be something similar to:

Sales Cumulative = 
                 TOTALYTD( 
                     SUM(Table[Sales],
                     DateTable[Date]
                 )
  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks!