Statistical Error Function in DAX / Power Bi - "ERF" in Excel

[Anonymous]

Someone know if ERF function is available in DAX, and in negative case, how to work around with that?

[OwenAuger · Accepted solution]

@Anonymous

The ERF function is not available in DAX right now, but you can use NORM.DIST to produce the same result as ERF.

This is possible since ERF(x) is the probability a normal random variable with mean 0 & variance 0.5 is between -x and +x.

A measure like the one below should give the same result as ERF in Excel (when passed a single argument), with <argument> being a measure or other scalar expression to be passed to the "ERF" function:

ERF =
2 * ( NORM.DIST( <argument>, 0, SQRT(0.5), TRUE() ) - 0.5 )

Regards,

Owen

[Anonymous]

@OwenAuger you killed it, this exactly attend  my demand. Thank you guy!

[Anonymous]

This function?

https://msdn.microsoft.com/en-us/query-bi/dax/iferror-function-dax