Power BI
Needs VotesMake built-in Power BI forecast capability available through Power Query/M function for data transforms
Rui Quintino on 03 Aug 2020 15:06:43
Power BI has a very reasonable and easy to use (though very often hidden!) built-in forecast capability,
*but* currently this is only available with specific line charts (see analytics tab), and it's only a visual forecast (though today we can at least export the values)
Idea is to make the same model/algorithm available through PowerQuery (including model parameters), so the resulting forecast could be handled as a regular power bi data table.
Similar request exists for Dax also, please vote here :) :
https://ideas.powerbi.com/ideas/idea/?ideaid=74dca84e-ad01-4345-9dfd-b13fc42536d5#submit-comment
Note: some more info on Power BI forecast (rather old though, not 100% sure reflects current algorithm, if anyone as better info/refs)
https://powerbi.microsoft.com/es-es/blog/describing-the-forecasting-models-in-power-view/
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-analytics-pane