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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Juan
Regular Visitor

NORMAL DISTRIBUTION FORMULA IN DAX

Hi,

 

I want to use a simple NORMAL DISTRIBUTION formula in DAX similar to DISTR.NORM formula in Excel.

Is it possible? I see other distributions in the list of Statistical Functions and I cannot understand why the Normal Distribution is not in the list.

 

Thanks.

9 REPLIES 9

Hi matthiumamet.

 

Many thanks for the info.

 

But your 2nd link doesn't works.

 

Try with this:

 

https://msdn.microsoft.com/en-us/query-bi/dax/norm-dist-dax

 

Josep.

mussol_
Advocate II
Advocate II

Hola Juan,

 

If you want to know how to manage a Normal Distribution on Power BI, I published a couple of videos about this.

 

Please, found them on:

 

https://youtu.be/5bPVMFrUnrU

https://youtu.be/t2ayEpbtDQ4

 

Thanks a lot.

Josep.

Anonymous
Not applicable

Hello,

I'm facing a problem during video #2. Why "Normal Z Value" is a "blank"? can you help me?

 

Thanks

Hi ,

I watched all 3 videos on Youtube and they are fantastic. I am also trying to use your pbix file and it is working, with one problem.

My values are all decimal numbers 6 digits after comma like 5,496113 & 6,112675 etc. When I use your X calculation in distribution normal table, it is returning me only integers 5,6,7 not the values between them. How can I change this code to sth that I can use for my numbers and round them to 2 or 3 digits.

Thanks in advance

DISTRIBUCION NORMAL = 
VAR MinNumber = FLOOR([X-3σ];1)
VAR MaxNumber = CEILING([X+3σ];1)
RETURN
    SELECTCOLUMNS (
        CALENDAR ( MinNumber; MaxNumber );
        "X"; INT ( [Date] )
    )

 

Hello Ozanboy,

 

did you try to multiply all values by 1000000 and divide final result by the same quantity?

 

I did not try but please, tell me if it works.

 

Thanks a lot!!

 

Josep.

Greg_Deckler
Super User
Super User

You can create this using the other base statistics functions:

http://blog.gnetgroup.com/bi/2012/07/24/create-a-dynamic-bi-distribution-chart-in-powerpivot-using-d...

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks, this helps, but I cannot get why the other distributions (binomial, poisson, exponential...) have their formula and NORMAL DISTRIBUTION doesn't...

No argument from me on that one @Juan!


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.