cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
brunozanoelo
Helper V
Helper V

Linear regression Example

Hi guys! Fine?

Can someone give me one example using Linear Regression in Power BI??

I found this topic but i didnt understand very well... i think one example will help a lot of users here!

@Greg_Deckler
http://community.powerbi.com/t5/Desktop/Simple-Linear-Regression-with-DAX/m-p/9272#M1736

Many Thanks!

1 ACCEPTED SOLUTION
Greg_Deckler
Super User
Super User

I actually wrote a blog article on it here:

 

https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-B...

 

 


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

View solution in original post

3 REPLIES 3
pfvg
Regular Visitor

Hello.

 

3 years late, but just found out a website that provides a very simple solution to this problem, for DAX beginners.

 

https://xxlbi.com/blog/simple-linear-regression-in-dax/

 

Regards.

Greg_Deckler
Super User
Super User

I actually wrote a blog article on it here:

 

https://community.powerbi.com/t5/Community-Blog/Correlation-Seasonality-and-Forecasting-with-Power-B...

 

 


@ me in replies or I'll lose your thread!!!
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Learn Power BI 2nd Edition

Hi @Greg_Deckler, fine?

 

Hello, Sorry but I did not quite understand your example, it seems to be a lot more complex than I imagined.

I just need to analyze past sales of sales to estimate future sales.

 

I noticed that other BI tools are simpler to do this calculation, I did a test on the tableau and it even applies the linear regression formula. 

Can you tell me how I can do this? I use an ODBC connection and I contain a sales table with date field, sales value ...

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors