Forum Discussion

Bullrich's avatar
Bullrich
Frequent Visitor
5 years ago

Cumulative Values at Stacked Graphic

I have the following problem. I need to created a graphic showing at the axis X = Month/Year and at the Y the Status (Qty) that should be accumulated by month (Jun-2020, Jul-2020 + Jun-2020, Aug-2020 + Jul-2020 and son on

Any any Ide

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    Bullrich , Try a rolling two month measure with a date table

    Rolling 2 = CALCULATE(sum(Sales[Sales Amount]),DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-2,MONTH))

     

    To get the best of the time intelligence function. Make sure you have a date calendar and it has been marked as the date in model view. Also, join it with the date column of your fact/s. Refer :radacad sqlbi My Video Series Appreciate your Kudos.

  • Bullrich's avatar
    Bullrich
    Frequent Visitor
    5 years ago

    Hi Amit,

    I checked the articles and watched your video series (very helpful) , unfortunately I couldn't make it, I'm new to Power BI.

    I also believe that I did not formalize my problem correctly. I need to create a "Stacked Chart" where X = Month / Year and Y = QTY (the Status field is a String it’s not a numeric field) and the displayed values must be accumulated month by month. 

    thank you very much for your help and patience.