Forum Discussion
12 Month Average
Hi Everyone, I wanted to calculate the average of last 12 month to forecast sales value. I have below table: Here I wanted to refer forecasting average value as actual to calculate next month...
danextian
Super User
Super UserI dont think that's what the user wants to achieve. You can see in his previous reply that his logic is recursive which is fairly easy in Excel but a complex one in Power BO
Hi,danextian .Thank you for your reply.
I agree with you that Power BI itself does not support recursive computation.
DAX may do similar recursive effect need to rely on the index column / date column to mark the data, in essence, not the same as the loop recursive.