PREDICT THE FUTURE with LINEAR REGRESSION / How to use LINEST function / Beginners Guide to Power BI

[@EyiBillion]

I have been saddled with the task in my office to generate some predictive analysis in my report. This nailed it. Thank you so much Fernan

[@jejetator]

Well done fernan. great video to forecast easily

[@tubeitz]

excellent explanation, thank you

[@devpattnayak9231]

Hi Fernan, Is there any solution to add Polynomial Trend chart in a scatter plot. I searched over internet but didn't find any solution.

[@p.j.882]

Microsoft excel office support has the best explanation of LINEST.

[@lorenzocassina2538]

Let's say I have a table with 100 different Jobs with all the Salaries and Years of experience. I'd like to do a linear regression on each of the different job.
How do I use LINESTX in a smart way, avoiding to write 100 DAX queries?
How can I link a dropdown list of the jobs, located in one tab of our dashboard, to LINESTX function? Is that possible? Basically how can I filter dynamically the table that is feeding LINESTX?

[@donatusvictor3500]

Thank you for the video, but i have a problem with my data when I add a column to the value section it will not work again. Please i need your help

[@RakeshSolanki-c4h]

I have Revenue and Cost in two different tables, how can I use the above to arrive at the Linear regression and predict for future years

[@ManishKumar-eu1qw]

@Solutions Abroad
how to pass parameter to public URL ??
please solve this problem

[@EyiBillion]

I used COUNT function instead of SUM function as used since i am working with months to predict future sales as i have sales for 6 months. The parameter function did not work since it is factoring SUM instead of COUNT in the calculation

[@comptegmail273]

Can you make some videos about machine learning algorithms in power bi

[@markconnor8667]

Very interesting

[@comptegmail273]

@@markconnor8667 do yo uhave any idea

[@John-cq6vh]

@@comptegmail273 I thing python can easily do that in power bi.