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]
                 )
ToddChitt's avatar
ToddChitt
Super User
3 years ago

I don't understand what you mean by "I have 5 purchases in Jan. So the monhly report will be 5"

Is this 5 DETAIL records, each on its own chart?