I am trying to calculate the average amount of hours spent on Projects per Quarter, I have been able produce the 4 week moving average.
and have produce a weekly break down of hours spent
But I have been unsuccessful in producing a Quarterly Calculated measure that takes in all the hours over the quarter to get an average.
Any help would be appreciated
Function LastPeriods() dynamically gives you the set of the selected Time dimensions member and the given number (minus one) of the previous Time members (of the same level) of the selected one: Calculated members in Time dimension
To get a previous quarter when a specific week is selected, you may use (LastPeriods(12, [Time].CurrentHierarchyMember) instead: it would give the set of the selected week and 11 previous weeks from that week.