Forum Discussion
Linking forecasted data to a table
I have some trending data (that's updated daily) that I'm using to forecast future data. I have exported the forecasted data to a .csv and used it in a table. However, since the referenced data is updated daily, it also changes the forecast. I can't seem to find a way to reference the forecasted data from the line chart in a table without manually exporting it, it would be great if when I refreshed the data, everything updated. Help?
2 Replies
- MFelix
Super User
Hi 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.
