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.
Hi all,
The dataset looks like the dataset below (simplified obviously, there are a lot more records and a lot more dimensions):
WeekID | CaseID | Probability of success |
1 | 1 | 5% |
1 | 2 | 76% |
1 | 3 | 29% |
2 | 1 | 8% |
2 | 2 | 71% |
2 | 3 | 30% |
Aside from the estimated amount of successes (which would simply be the sum of the probability of success per unique case), I am looking for an upper and lower bound of the expected successes (at a given confidence interval, for example 95%).
I know there are some statistical functions in Dax, but I didn't find the function, or combination of functions required to do this.
If Dax is not sufficient, it is an option to do it in R or Python, but Dax is preferred.
Any help is appreciated.
Thanks in advance!
Kind regards,
Will
Hi @Anonymous ,
Did you mean CONFIDENCE.NORM function? Please refer to the document as below.
https://docs.microsoft.com/en-us/dax/confidence-norm-function-dax
Regards,
Frank
Hi @Anonymous ,
Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.
Regards,
Frank
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 |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |