Skip to main content

    Power BI

    New

    Add correlation measure (equivalent to Excel CORREL function)

    Vote (10) Share
    Richard Hurford's profile image

    Richard Hurford on 15 Sep 2015 22:45:39

    Comments (4)
    Richard Hurford's profile image Profile Picture

    4cbb56e8 8d01-4327-bf18-41937bdbec52 on 05 Jul 2020 23:10:04

    RE: Add correlation measure (equivalent to Excel CORREL function)

    A simple correlation % would suffice.

    Richard Hurford's profile image Profile Picture

    ad029e17 27bf-4edf-92a9-7df0c090ed04 on 05 Jul 2020 22:56:53

    RE: Add correlation measure (equivalent to Excel CORREL function)

    Good idea...speaking of R2 and regression line equation: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/30957685-create-a-simple-method-to-add-the-trend-line-equat

    Richard Hurford's profile image Profile Picture

    177bbe1e e5b3-43ec-bc69-24f6db121c99 on 05 Jul 2020 22:23:48

    RE: Add correlation measure (equivalent to Excel CORREL function)

    I love the new feature to show trend lines on charts. Thanks!

    The only thing it's missing is the option of displaying the R2 value and/or or the fit line equation. Even if the equation couldn't be displayed on the report, it would be nice to be able to see what it is.

    Richard Hurford's profile image Profile Picture

    177bbe1e e5b3-43ec-bc69-24f6db121c99 on 05 Jul 2020 22:20:18

    RE: Add correlation measure (equivalent to Excel CORREL function)

    This would be extremely helpful. Any basic measure of correlation strength would be so helpful.