Forum Discussion

JanCab's avatar
JanCab
Frequent Visitor
4 years ago

Calculating future rolling average

Hello,   I would like to ask you for your help with a DAX formula which would calculate value of future unit sales, based on rolling average of previous 12 month.   See below - there are blue val...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

Hi,

I am not sure if I understood your correctly, but I think the numbers are showing 14 months rolling average.

I tried to solve this in Power Query.

Please check the attached file. I do not know how your calendar table looks like, but I hope this helps to provide an idea.

Thanks.