Forum Discussion
Solved
Moving Average
I need a moving average in the future and I expect to have a different value every month, the dax function I use is: AVRG = CALCULATE ( AVERAGEX ( KMR, KMR[MQTY] ), DATESINPERIOD ( ...
You are welcome. This measure works
Measure = divide(calculate(sum(kmr[mQty]),datesbetween(calendar[date],min(calendar[date]),eomonth(min(calendar[date]),2))),3)Hope this helps.
You are welcome. This measure works
Measure = divide(calculate(sum(kmr[mQty]),datesbetween(calendar[date],min(calendar[date]),eomonth(min(calendar[date]),2))),3)Hope this helps.
Thank you very much Ashish_Mathur !!!
That did work perfectly.
I have another question regarding this measure, but will post it as another question and will tag you and mark this answer as accepted solution.
You are welcome.