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"
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!
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! 😊
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!
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.
Hello Gregg, Diana here! If you can combine all three tables into one big table, that might help with the DAX calculations (if they all have the same columns). If you have completely different data that cannot be combined, then I would do separate regression for each event. I have a video on multiple linear regression here as well: Multiple Linear Regression in Power BI using R Script, but I'm not sure it will help you unless you have one big table! Sorry I couldn’t help more!
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?
![Blox Fruits Dragon Rework Update [Full Stream]](http://i.ytimg.com/vi/EqDAp8udhm0/mqdefault.jpg)
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"
Since this post, Power BI now has the LINEST and LINESTX functions which perform the regression calculations automatically.
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!
Great work. Very clear and helped me figure our how to use Power BI in regression analysis. Keep up the good work.
Great work ❤
Excellent tutorial, thank you ,Diana!!!
Awesome job Diana!!! I wished I saw this video first
Excellent presentation
amazing, Great tutorial, thanks for sharing
thank you from Thailand
Love this sharing, excellent job. Thanks.
Excellent presentation - I would give it an A+
:)
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! 😊
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!
How you created the last visual. I mean how you plotted both salary and predicted salary in a single visual.
Hi, Did you find the answer to this?
Thanks
Thank you very much, helped insanaly. God bless you!
How did u combine all into one visual???
Hi, Did you find how it's done?
Thanks
please share how you created mesaures for m,b
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
brilliant, thank you!
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.
Hello Gregg, Diana here!
If you can combine all three tables into one big table, that might help with the DAX calculations (if they all have the same columns).
If you have completely different data that cannot be combined, then I would do separate regression for each event.
I have a video on multiple linear regression here as well: Multiple Linear Regression in Power BI using R Script, but I'm not sure it will help you unless you have one big table!
Sorry I couldn’t help more!
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?