Upper and lower bound given probabilities

[Anonymous]

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

[v-frfei-msft]

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

[v-frfei-msft]

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