cancel
Showing results for
Did you mean:
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
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...

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
3 REPLIES 3
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.

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...

Become an expert!: Enterprise DNA
External Tools: MSHGQM
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Helper V

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 ...

Announcements

Power BI May 2023 Update

Find out more about the May 2023 update.

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors
Top Kudoed Authors