Help with cumlative total

[Dsch1971]

Hi All

Can anyone please help?

I have a measure called True Headcount (As in the picture).

I need to add a measure that adds a cumlative total (Total) i.e

Total for April will be April

Total for May would be April + May

Total for June would be April + May + June etc.

How can I achieve this please?

I have a date table called Calendar that has as field in it called date.

Richard 

[SpartaBI]

@Dsch1971 in case the granularity of each month is the end of it then this will work:

RT = 
VAR _current = MAX('Calendar'[Date])
VAR _result =
CALCULATE(
	SUM('Table'[True Headcount),
	REMOVEFILTERS('Calendar')
	'Calendar'[Date] <= _current
)
RETURN
	_result

But I'm not sure this is the exact case you have. Let me know.

      

Showcase Report – Contoso By SpartaBI