cancel
Showing results for
Did you mean:
Frequent 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.

8 REPLIES 8
Super User

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

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

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Frequent Visitor

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

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

Super User

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

No argument from me on that one @Juan!

### I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Regular Visitor

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

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.

Frequent Visitor

Regular Visitor

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

Hi matthiumamet.

Many thanks for the info.

Try with this:

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

Josep.

Frequent Visitor

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

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.

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

Regular Visitor

## Re: NORMAL DISTRIBUTION FORMULA IN DAX

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.

Announcements

#### Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

#### Community News & Announcements

Get your latest community news and announcements.

#### Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Top Kudoed Authors
Users Online
Currently online: 342 members 3,389 guests
Recent signins: