Forum Discussion
Dynamic Moving Average per Day based on multiple values
Hi All, I am trying to achieve a Moving Average per Day with a dynamic adjustment. My issue is that I have multiple values per day and seem to be struggling with that. I have already made a movin...
amitchandak
Super User
Super UserAnonymous , Try a measure like with help from date table
4 Day Avg = CALCULATE(AverageX(Values('Date'[Date]),calculate(Sum('Table'[Value])))
,DATESINPERIOD('Date'[Date ],MAX('Date'[Date ]),-4,DAY))
Hi amitchandak, I have tried it like that few times but it just shows blank even though I know the relationship works through other plots