Cannot see the wood for the trees as where the error is here. when using the LN function in DAX.
CI Lower = [1-e_i/d_i]^EXP(NORM.S.INV(0.0025)/LN([1-e_i/d_i])*[s.e]/[1-e_i/d_i])
Hi @Route217 ,
Sorry for the delay.
By my tests, I cannot reproduce your issue.Since I do not know your [1-e_i/d_i] so I replace it with a static value.Here is the test result.
If you sitll need help, could you share some data sample and your desired output so that we could help further on it?
firstly thanks for the feedback and ill share some data later on.
Kudos to you if you earned one of these! Check your inbox for a notification.
Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.
Find out where you can attend!