Linear Regression analysis function in Power Pivot (line of best fits with R2 vaules)

[stephen_hext]

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.

[piers_williams]

'+1. How can do people do trend KPIs with out it?

[fbaritto1]

I agree... This is a very important issue

[jschlereth21]

Even something simple like Excel allows FORECAST(x, known_y's, known_x's) would be great.