Open Side Menu
Skip to contentBrand Logo
Forums
Inspiration
Ideas
Communities
Blogs
Learning
Support
RegisterSign In
  1. Microsoft Fabric Community
  2. Power BI forums
  3. DAX Commands and Tips

Forum Discussion

vandavarosi's avatar
vandavarosi
Regular Visitor
3 years ago

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's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

vandavarosi , 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

https://community.powerbi.com/t5/Desktop/Recursive-Measure-Calculation-Problem-in-Power-BI/m-p/458562

https://www.pbiusergroup.com/communities/community-home/digestviewer/viewthread?MessageKey=8a21f79b-f0b6-42e7-8e97-6b5bbc28d08c&CommunityKey=b35c8468-2fd8-4e1a-8429-322c39fe7110&tab=digestviewer

Related content
  • Forecasting with DAX

    2 months ago
    kowas2
  • Forecast Calculation

    5 years ago
    Gaurav_Lakhotia
  • Calculating Forecasting Accuracy

    4 years ago
    kukszi
  • Group By not continuously applying

    2 months ago
    KylePalardy
  • Calculate difference between versions of Forecast data

    10 months ago
    mbudiman
  • © 2026 Microsoft
  • Manage cookies
  • Privacy & cookies
  • Terms of use
  • Trademarks
Your Privacy Choices Consumer Health Privacy