Forum Discussion

harry6810's avatar
harry6810
Frequent Visitor
2 years ago
Solved

Stacked chart

Hey,

How can I create a stacked chart where each subsequent data point represents the cumulative sum of the previous values?

 

Need Help
Show and Tell
  • Joe_Barry's avatar
    Joe_Barry
    2 years ago

    Hi harry6810 

     

    You would need to create a cumulative measure

    Culumative Amount =
VAR MaxDate = MAX ( 'Date'[Date] ) 
RETURN
    CALCULATE (
        [Sales Amount],   /// Sum of the amountin your table or a count of an id       
        'Date'[Date] <= MaxDate,  
        ALL ( Date )               
    )

     

    There are also a number of Time Intelligence measures you could use like

    TOTALYTD = TOTALYTD([SalesAmount], 'Date'[Date])
TOTALQTD = TOTALQTD([SalesAmount], 'Date'[Date])
TOTALMTD = TOTALMTD([SalesAmount], 'Date'[Date])

     

    Hope this helps

    Joe

1 Reply

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage
    2 years ago

    Hi harry6810 

     

    You would need to create a cumulative measure

    Culumative Amount =
VAR MaxDate = MAX ( 'Date'[Date] ) 
RETURN
    CALCULATE (
        [Sales Amount],   /// Sum of the amountin your table or a count of an id       
        'Date'[Date] <= MaxDate,  
        ALL ( Date )               
    )

     

    There are also a number of Time Intelligence measures you could use like

    TOTALYTD = TOTALYTD([SalesAmount], 'Date'[Date])
TOTALQTD = TOTALQTD([SalesAmount], 'Date'[Date])
TOTALMTD = TOTALMTD([SalesAmount], 'Date'[Date])

     

    Hope this helps

    Joe