Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)
I have some DAX calculated columns in which I want to use CONFIDENCE.NORM to return the upper and lower bounds of a forecast based on a 95% confidence interval, however it seems that Excel 2016 does not have this function. I am wondering if anyone knows an alternative to this that I can use in Excel 2016. I have attached the workbook below - the problem calculation is in the Facts_Calc table of the Data Model. Forecast Problem