Forum Discussion

kristi_in_heels's avatar
kristi_in_heels
Icon for Helper II rankHelper II
3 years ago
Solved

Help with Cumulative Totals

Hello,   I have a set of data which I am trying to show in a line graph visual. I want to be able to show 2 separate lines: - Value per month - Cumulative Value which obviously increases per mont...
Need Help
  • isjoycewang's avatar
    isjoycewang
    3 years ago

    Hi kristi_in_heels,

     

    Exercise File

    Since you're using inactive relationship between 'Calendar' and 'Table', please modify the measures as below:

     

    Forecast Value = 
CALCULATE( 
    SUM('Table'[Baseline Forecast]), 
    USERELATIONSHIP('Calendar'[Date], 'Table'[Date]))
    Cumulative Value = 
var maxdate= MAX('Calendar'[Date])
return
CALCULATE( 
    SUM('Table'[Baseline Forecast]), 
    FILTER(
        ALL('Calendar'), 
        'Calendar'[Date] <= maxdate), 
    USERELATIONSHIP('Calendar'[Date], 'Table'[Date]))

     

isjoycewang's avatar
isjoycewang
Icon for Solution Supplier rankSolution Supplier
3 years ago

Please try if this works for you. If not, please share dummy data and let us know more info about your chart.

Thanks.

 

 

Cumulative Value =
var maxdate= MAX('Table'[Date])
return
CALCULATE( 
    SUM('Table'[Value]), 
    FILTER(
        ALL('Table'), 
        'Table'[Date] <= maxdate))