Forum Discussion
Strange error n NORM.S.INV function DAX when creating a column.
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[column...
Such a question can't be answered without actually showing us the file.
The only thing one can say is... make sure the data type of the column is correct. Also, since the normal distribution has a support which is the whole real line, for some values the number returned from the inverse of the distribution function can be too large, indeed.
Best
D
The only thing one can say is... make sure the data type of the column is correct. Also, since the normal distribution has a support which is the whole real line, for some values the number returned from the inverse of the distribution function can be too large, indeed.
Best
D