Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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.
Is there a process to look at the inner working of Excel formulas?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
26 | |
21 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |