Forum Discussion

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago
Solved

All years cumulative

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...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

     

M_SBS_6's avatar
M_SBS_6
Helper V
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.