Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello Guys,
I am creating a kind of "Sales Forecast" model. To plan ahead, i am using the 6months average of the Actual Sales ahead. In Excel is quite simple, but how to implement in DAX?
To better explaing, i am adding an image with the Actual Sales until September 2017, and how i want calculate the months ahead. Does anyone has any clue?
Thank you so much
Based on my experience, you may try to invoke a recursive custom function in Query Editor.
https://msdn.microsoft.com/en-us/library/mt185361.aspx
Hello @v-chuncz-msft! thank you so much for your time ...
I would like to do it using DAX formulas, because i will use other Dimensions do Categorize the forecast (Products, Customers etc)...
As far as I know, there is no elegant way.
@v-chuncz-msft yeah, i tried those "no elegant" ways, but the model is colapsing after the 6 month calculation. Too much "IF"s
Thats so annoying this situation for circular reference limitation...
Cheers
It's a mathematical problem of finding the general formula of recurrent sequence.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |