Linear regression Example

[brunozanoelo]

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!

[pfvg]

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 · Accepted solution]

I actually wrote a blog article on it here:

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

[brunozanoelo]

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