topic Re: Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016) in DAX Commands and Tips

Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)

JollyRoger01 — Tue, 27 Jul 2021 00:17:14 GMT

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

Re: Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)

Anonymous — Wed, 28 Jul 2021 10:04:33 GMT

Well, the easiest way is to take a look at how the formula for the bounds is written and then calculate it in your model from scratch.

Re: Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)

JollyRoger01 — Wed, 04 Aug 2021 05:37:34 GMT

Is there a process to look at the inner working of Excel formulas?

Re: Alternative to CONFIDENCE.NORM function (function is missing in Excel 2016)

Anonymous — Thu, 05 Aug 2021 08:40:14 GMT

You can either go to the online documentation of the Excel functions or find the definition of the functions in places like Wikipedia, Wolfram Alpha or any good source of mathematical knowledge.