Replacing NaN with 0

[zilaifeng]

Hello,

I'm looking for a way using DAX function to replace all the NaN values in my data to 0. (I do not have the original data file so that I cannot use query editor.)

Thanks!

[Mariusz · Accepted solution]

Hi @zilaifeng 

You can use if error like below.

Column = IFERROR('Table'[Custom], BLANK())

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous]

Thanks for the quick solution.