Normal distribution

[Anonymous]

Dear DAX fellows,

I need to calculate some process statistics, and so far I found many statistical functions in DAX, including formulas for CHI²-distribution, exponential distribution and so on.

Why is there no normal distribution? In Excel this is NORM.S.DIST - but in DAX?

I don't want to prepare a lookup table giving the z-level and cumulated percentile... I'd rather like to do it in a measure.

Any ideas?

Many thanks in advance!

[Stachu]

there is idea for it, which means it's probably still not included
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31641976-add-the-normal-distribut...
below is the idea for a workaround
https://community.powerbi.com/t5/Desktop/NORMAL-DISTRIBUTION-FORMULA-IN-DAX/td-p/167215

[Anonymous · Accepted solution]

Wow - I just saw it popping up after updating PowerBI. It must have been implemented in the July Update...