Skip to main content
Microsoft Idea

    Power BI

    Needs Votes

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

    Vote (60) Share
    Power BI User's profile image

    Power BI User on 04 Feb 2015 02:52:11

    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.

    Comments (3)
    Power BI User's profile image Profile Picture

    Jonathan Schlereth on 05 Jul 2020 23:25:13

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

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

    Power BI User's profile image Profile Picture

    Felipe Baritto on 05 Jul 2020 22:35:55

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

    I agree... This is a very important issue

    Power BI User's profile image Profile Picture

    Piers Williams on 05 Jul 2020 22:19:01

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

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