Forum Discussion
Exponential Curve Target Line
Hello all, I'm trying to figure out how to model the following exponential curve in PBI based on averages of historical data. I have tried plotting an average of prior year results and that seem...
radas Sounds like you need linear regression. There are lots of articles on it with DAX, even a default quick measure as well as a quick measure in the Quick Measure Gallery. My book, DAX Cookbook has an example of a deseasonalized linear regression. I don't have a copy with me at the moment, it is in like Chapter 8 or 12 I think.
https://community.powerbi.com/t5/Quick-Measures-Gallery/Simple-Linear-Regression/m-p/247439#M55