Cumulative Values at Stacked Graphic

[Bullrich]

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

[Bullrich]

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.

[Ashish_Mathur]

Hi,

Share the link from where i can download your PBI file.

[Bullrich]

Hi Ashish,

I created 2 sample files (.PBIX and .XLSX), you can find the files here:  https://1drv.ms/u/s!AgdS8XqKTHEXmU_VWBiTWzesMAo4?e=FCS9DP

Thanks a lot, AlexBullrich

[Bullrich]

Hi Ashish,

Any thoughts, I can create the Calendar date table and mark as the date in model view, link it with my date column in my fact table. The problem is that I can handle the measure. I need to create a test PBIx file onde I can't share the official one that I'm working on.

Thanks a lot, AB

[amitchandak]

@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.