Linear Regression analysis function in Power Pivot (line of best fits with R2 vaules)
Could we have a function in Power Pivot to allow for calculation of Linear regression analysis so the values can be used in dash boars and pivot tables which can be sliced. Along with a confidence level.
Even something simple like Excel allows FORECAST(x, known_y's, known_x's) would be great.
Felipe Baritto commented
I agree... This is a very important issue
Piers Williams commented
+1. How can do people do trend KPIs with out it?