Forum Discussion
Linking forecasted data to a table
Super UserHi Anonymous ,
To what I can understand you want to present the values from the forecast in a table visualization.
The forecasting capability is only available on some visualizations (not on table visualization), and this is based on the ETS AAA and the ETS AAN, this values are not stored in the model and are calculated based on your selection
Check this blog post with some details
https://powerbi.microsoft.com/en-us/blog/describing-the-forecasting-models-in-power-view/#ETSAAA
What is the purpose of the table visual is to show the values of the forecast in another way than the line?
Believe that you would need to redo the calculations as Power BI does, I have been looking and don't find any of the parameters definition that are used as default in PBI.
Greg_Deckler you have played around with so many calcuations, did you find out or made any forecast simulation has Power BI does?
- Greg_Deckler
Community Champion
Anonymous MFelix I have done some forecasting work with Power BI going way, way back, mostly focused around seasonality. I have the basics of it here:
There is a much more involved example in my book, DAX Cookbook that you can get the DAX code here:
https://github.com/gdeckler/DAXCookbook
Chapter 12, Recipe 8.
