Forum Discussion

sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Cumulative Line Chart Help

Hi,   I need a cumulative line chart but am stuck.   I have month along the bottom of the chart and then it needs to do a sum of funding but it has to sum whatever is in RateBand and be able to f...
Need Help
sdukes_88's avatar
sdukes_88
Frequent Visitor
9 years ago

Sorry I don't think I was very clear. I mean I need the cumulative total running across the months.

 

So in the line chart, Aug+Sep+Oct etc

 

So if Aug is 20,000 and September is 300,000 the point at September for the line chart should be 320,000 etc 

Baskar's avatar
Baskar
Resident Rockstar
9 years ago

Ooh Cool,

 

Create new measure for this,

 

 

 

Running Count1 = CALCULATE(COUNTA('Date Master'[MonthInCalendar]),FILTER(ALLSELECTED('Date Master'[Date]), 'Date Master'[Date] <= MAX('Date Master'[Date])))

 

 

 

let me know if any help.

 

 

 

 

 

 

  • sdukes_88's avatar
    sdukes_88
    Frequent Visitor
    9 years ago

    Thanks for this - my only problem is that Month is a text field i.e. 01-Aug, 02-Sep etc so it doesn't seem to like this.

     

    If it helps I have 'Period' which is numeric?