Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MartaCB
Frequent Visitor

NORM.S.INV and NORM.INV in M

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!

 

5 REPLIES 5
ImkeF
Super User
Super User

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

ImkeF
Super User
Super User

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

MartaCB
Frequent Visitor

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
Super User
Super User

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...

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:

MartaCB_0-1695578994254.png

And the same in DAX:

MartaCB_1-1695579365600.png

 

Thank you!

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors
Top Kudoed Authors