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
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?