The new DAX function LINEST() can be used also for non-linear regression.
Depending on the type of relation (logarithmic, exponential etc) we can adjust the LINEST() parameters to get the desired prediction.
In this video we predict an outcome based on a logarithmic curve where the equation will be: y = a + b*ln(x)
Here is the link for the pbix file:
drive.google.com/file/d/1WLjs...
====CHAPTERS====
01:00 Dataset presentation
01:26 Logarithmic growth
03:08 Scatterplot in Power BI
04:18 LINEST() function
05:10 Adjust the LINEST() function for logarithmic
06:34 DAX Measure for prediction
Here is the link to the pbix file:
drive.google.com/file/d/1VLkY...
#dax #powerbi #linest #dataanalysis #businessintelligence #nonlinear #regressionanalysis
4 мар 2023