DAX NORM.S.INV returns error when trying to add a column measure

0
votes

I'm trying to add a calculated column in Power BI modeler with DAX. In a column X I have a probability, say 0.08 or 0.01 For that column X I'd like to add the calculation of NORM.S.INV(mytable[columnX]) I get an error: An argument of function 'NORM.S.INV' has the wrong data type or the result is too large.

When I enter NORM.S.INV(0.08) or some other value of column X this works fine. Same table in Excel with this function works fine as well.

What am I missing?

1
functionpowerbidax

1 Answers

0
votes

Check the column data type (not only the format) is numeric.
Also, wrap the function inside a ROUND() to reduce the number of decimals.