All years cumulative

[M_SBS_6]

Hi, 

I have 8 years worth of data and what I'd like to see is the all years total cumulative value split by month as the x-axis.

The date is app_date (which I'll use the month as the x-axis and the value app_value

App_date  app_value.  Cumulative 

Jan.              1000.           1000

Feb.              3000.           4000

Mar.              2000.           6000

Apr.               1000.           7000

May.               2000.         9000

Jun.                1000.          10000

Jul.                 4000.           14000

Aug.               1000.          15000

Sep.               1000.           16000

Oct.                2000.          18000

Nov.               2000.           20000

Dec.                5000.          25000

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[CoreyP]

If I understand you correctly, you mean you want to see the cumulative value for january of all years aggregated together? Like below...

Sample Data on the Left

Cumulative aggregated by month for all years on the Right

[M_SBS_6]

Hi @CoreyP @ yes, that's exactly right. If you would be so kind to share how you got to this, that would be great thank yo

[v-xinruzhu-msft · Accepted solution]

Hi @M_SBS_6 

You can refer to the following solution.

Sample data 

Create a measure

Measure = CALCULATE(SUM('Table'[app_value]),'Table'[App_date]<=MAX('Table'[App_date]),ALLSELECTED('Table'))

Then put the measure to the visual

Output

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.