Skip to Content
Former Member
Jun 02, 2010 at 11:53 AM

Formula for previous months avg. - LAG ? CALCULATE ?


Hi all

I Want to make a KPI which uses the average of the last 6 months for a certain parameter.

So I need to create a virtual variable which should be equal to the avg. of past 6 months and then put in the formula to get desired results.

It should give correct result when viewed on - monthly, quaterly, yearly basis. (in all cases virtual variable should give the avg of last 6 months and then the sum/avg, time consolidation to be applied on KPI)