Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
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.
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:
Thanks a lot.
Josep.
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.
You can create this using the other base statistics functions:
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!