PWR Dax formula error

[Anonymous]

Hi Experts

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])

[v-piga-msft]

Hi @Anonymous ,

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?

Best Regards,
Cherry

[Anonymous]

Hi Cherry

firstly thanks for the feedback and ill share some data later on.