Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Normal distribution

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!

  • Anonymous's avatar
    Anonymous
    8 years ago

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

2 Replies