To know precisely how your table calculation is calculating, we must know how you table/view is structured. What dimensions are included on the view with the WINDOW_AVG calculation?
Can you share a packaged workbook, or at the very least, a sample set of your data?
Hi Mark, I uploaded a sample copy of my packaged workbook.
Rows: Measure names
Text: Measure Value
Level of Detail: Fiscal Month
Measure Values: YTD Actual Equip $ Avg
Prev YTD Actual Equip $ Avg
Filters: Measures Names
MY(Fiscal Month Filter)
The results should be on the worksheet labeled "Prev Year and YTD".
That's quite a workbook! But I'm not seeing data for 2012 that you referenced in your example. Is that not in here?
In the version you shared, if you select Feb-2011, then "Prev Year..." calculates for the full 12 months: 8,880,572 / 12 = 740,048. "YTD Actual..." calculates avg of Jan-2011 and Feb-2011 only: $2,972,116 / 2 = 1,486,058.
Is this not the desired behavior? I arrive at both numbers averaging the monthly figures in Excel as well...I'm afraid I still don't understand what discrepancy you're seeing. Sorry-I'm not usually this daft...
After looking further into my dashboard I discovered the data didn't update. The Window_Avg is working fine.
Ha! It happens. Cheers.