Forum Discussion

Regular Visitor

9 years ago

Solved

Rolling Sum Calculation

Hello to all, I'm stuck with a simple task from a while now. I have a table that contains fields as follow: Date: W/O id: 2016-01-01 F7895 2016-01...

9 years ago

I think this might be close to what you need?

3 Month RT MEASURE = CALCULATE (
    COUNTROWS ( 
    	DATESINPERIOD (
        	'Table'[Date],
			LASTDATE('Calendar'[Date]),-3,MONTH)
			),
			FILTER (  'Calendar', 'Calendar'[Full Month] = "Full Month" )
	)

Phil_Seamark
9 years ago
Sean did the hard yards. I just tweaked it for the cumulative requirement.

Regular Visitor

9 years ago

Thank you Guys! With all your help and the final solution from Phil it works great, exactly what I need.

Have a good day!

Microsoft Employee

9 years ago

Sean did the hard yards. I just tweaked it for the cumulative requirement.

Related content