Join Diana Arciniega on May 24 as she walks us through part 2 of How to do Multiple Linear Regression in Power BI Using R Script at the Calgary Power Platform User Group on May 24 at 4 pm MST! Register today! bit.ly/3Om08qY

It's amazing. Something that takes us literally 30 seconds in Excel will now take us over 4 hours including time spent looking up for you tube tutorials in this "new software"

Great work. Very clear and helped me figure our how to use Power BI in regression analysis. Keep up the good work.

This is one of the best tutorials i ve seen in a long time :) i did the formula in excel and i was sceptical to be be honest but everything worked exctely as you said :) thanks!

How you created the last visual. I mean how you plotted both salary and predicted salary in a single visual.

Excellent tutorial, thank you ,Diana!!!

thank you from Thailand

This is great tutorial! I did find myself struggling for a bit, because my x-value was a Measure, while my Y value existed in a separate data table. I had to create a calculated table (my data set is relatively small in this regression analysis) with a Dax formula like: LR Table = SUMMARIZE( 'vw_PropertyDesignations', 'vw_PropertyDesignations'[PropertyKey], "Xvalue", [ServiceRequests_AVG_Days_To_Complete_This_Month], "YValue", AVERAGE('vw_PropertyDesignations'[UnitCount]) ) In my scenario, [PropertyKey] does not require an explicitly declared aggregation function because its already grouping, by virtue of SUMMARIZE() parameters, and for [UnitCount] which is static, I was able to aggregate with Average. I also had to create the measures and calculated columns in this table so they could be referenced within the same scope. Hope that helps if you find yourself in similar situation! 😊

Awesome job Diana!!! I wished I saw this video first

Why in the world isn't this just a built in feature? I mean... Excel has this. I'd bet more statistical software has this.... Thanks for showing us a way to do this!

Excellent presentation

amazing, Great tutorial, thanks for sharing

How did u combine all into one visual???

Love this sharing, excellent job. Thanks.

Excellent presentation - I would give it an A+ :)

What I do not get is why Microsoft makes it so hard to get the regression results. I mean in Excel there are many tools like the data analysis add in, where you get the intercept, slope and p-values with a few clicks. Why don't Microsoft just integrates that in Power BI?

Diana - I am stuck on a problem - trying to get linear regression to work in Power BI to predict future revenue based on client counts - problem is, my data is split across 3 tables. Wondering if you might give me some pointers or help. I'm stuck after trying to sort this out for a week.

Thank you very much, helped insanaly. God bless you!

please share how you created mesaures for m,b

brilliant, thank you!

Thankyou for your tutorial:) Can i know how to show the formula y = mx+b to power bi? So others know what formula we get to this condition