Skip to main content

    Power BI

    New

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

    Vote (58) 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

    ad029e17 27bf-4edf-92a9-7df0c090ed04 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

    5ea5d5a9 1375-4bc3-b70e-ee907301953c 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

    0f6888d2 b345-4429-a38a-5f151b52219e 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?