Provide a link to a sample PBIX file with a copy of the solution.Visualize and interpret the DAX calculations.Add a Linear Regression Trendline to a Dataset and Report using custom DAX.
In this article (and related video tutorial) I'll cover the following:
Linear trendlines can be useful for trendspotting, forecasting, and pattern identification in data. After designing and creating the example, I thought it would be useful to share with the Community. Recently I was asked to provide an example of a custom Linear Regression Trendline in Power BI that can dynamically re-calculate for both different levels of a Date hierarchy along with different filter selections. Custom Linear Regression DAX expressions give you insights into all components of the Y = MX + B equation.