Forum Discussion
Jodallen123
Helper I
Helper IRolling average with blanks present
Hi, I am trying to create a 4 week rolling average measure. Below is what I have so far and it works on my sales data, but for some reason I can't seem to make it work on my budget data (mo...
Update:
I ran a test with the sample data you provided, and your 10 days rolling average measure actually provides the right values. Or do you want a different beviour, for example exclude non working days? .
Anyway, there is no need to use AVERAGEX here, so for performance I would use code like below.4davg_ratioBU= VAR MaxVisibleDate = MAX('Master Time Table'[Date]) VAR RollingWindow = DATESINPERIOD('Master Time Table'[Date], MaxVisibleDate, -10, DAY) RETURN DIVIDE(CALCULATE([Budget], RollingWindow), COUNTROWS(RollingWindow))
sjoerdvn
Solution Sage
Solution SageMy guess is that the daily budget is not 6.00 for January, but more to the tune of 6.13, that would explain the numbers. Please check the formatting you are using. Or are you (re)calculating the daily budget in that measure?
Jodallen123Helper I
Helper II am an idiot, you're absolutely right!