Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I have the following Expression to make a rolling 52/53 week avg (rolling n period)
Count(distinct [OrderID] ) as a 1st measure
rangeavg(above(Count(distinct [OrderID] ),0,53)) as a 2nd measure (this is my rolling n period)
WeekEnd(OrderDate) as a dimension
date period from 2013 to the present
I wish the second measure to start from 2014, but I seem to loose the avg values if I place the exclusion {<Year-={'2013'}>} please help
the avg 2013 values are needed to calculate the n period
please help
Try this
RangeAvg(Above(Count(DISTINCT {<Year>} [OrderID]), 0, 53)) * Avg({<Year-={'2013'}>} 1)
Try this
RangeAvg(Above(Count(DISTINCT {<Year>} [OrderID]), 0, 53)) * Avg({<Year-={'2013'}>} 1)
Hi
Sunny your amazing as always
works brill
thank you