Forum Discussion
vandavarosi
3 years agoRegular Visitor
Continuous forecast calculation
Hi, I would like to calculate the next year forecast in my power BI model based on the currectly available data. Calculation method should be: 3MO AVERAGE forecast * growth date; however, t...
amitchandak
Super User
3 years agovandavarosi , In power bi recursive calculations like this, are very limited
refer:
https://www.thepoweruser.com/2019/07/01/recursive-functions-in-power-bi-power-query/
https://community.powerbi.com/t5/Power-Query/Simple-recursive-calculation-Power-Query/td-p/1093141