How to find the confidence intervals of a correlation coefficient

[CloudMonkey]

Hi,

Please can you tell me if it's possible to find the confidence interval of a correlation coefficient in Power BI? (I'm looking to plot a graph of how a correlation coefficient changes over time, but would like to add the 80% high and low confidence intervals to give some context to the reader). I know confidence intervals can be found in one of the Excel Analytics add-ins but I'm trying to automate the reporting process using Power BI.

Thanks,

CM

[Yggdrasill]

Don't believe there's (yet) a built-in addon in Power BI that calculates the confidence intervals for you. However, if it can be formulated it can be DAX'd. You can calculate standard deviation by built-in function, you have the sample size - now you just gotta find the rest.

Find out how to calculate confidence intervals and create the formula by yourself. You can use the excel add-on to double check your calculations.