NORM.S.INV and NORM.INV in M

[MartaCB]

Hi,

I am trying to replicate these functions that work well with DAX and Excel in the Power Query:

NORM.S.INV inverse of the standard normal cumulative distribution

NORM.INV inverse of the normal cumulative distribution

I am trying to find a solution with M but I am open to read solutions with R or python.

Thank you!

[ImkeF]

Hi @MartaCB ,
thanks for the feedback.
I have added a sample file (to the blogpost as well).
Please let me know if that works for you.

[ImkeF]

Hi @MartaCB ,
I published a version for the NORM.INV here: Excel NORM.INV function in Power Query and Power BI – (thebiccountant.com)
If you can provide an understandable algorithm for the NORM.S.INV function, I might give it a go as well.

[MartaCB]

Hi,

When I did my first research online, I found that link. I was unable to make it work.

I am after the NORM.S.INV (or NORM.INV when the mean is 0 and the standard deviation is 1) of a given probability.  

Is it possible for you to publish how that code works? As I said, I was unable to make it work.

Thank you,

Marta

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[MartaCB]

Hi,

I do not think a sample is needed as the equation works directly with the probability.

NORM.S.INV is the same as NORM.INV when mean is 0 and standard deviation is 1.

If I assume the probability is 0.8, I get this in excel:

And the same in DAX:

Thank you!