Syntax
CONFIDENCE.T(alpha,standard_dev,size)
Tutorial with example
In today’s video I will explain how to calculate confidence intervals in power bi and why they are useful.

Download example files:
Download the pbix and excel file here.
Remarks
If any argument is nonnumeric, CONFIDENCE.T returns the #VALUE! error value.
If alpha ≤ 0 or alpha ≥ 1, CONFIDENCE.T returns the #NUM! error value.
If standard_dev ≤ 0, CONFIDENCE.T returns the #NUM! error value.
If size is not an integer, it is rounded.
If size equals 1, CONFIDENCE.T returns #DIV/0! error value.
Was this helpful?
Leave a Reply