zilaifengFrequent Visitor7 years agoSolvedReplacing NaN with 0 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! Show MoreMariusz7 years agoHi zilaifeng You can use if error like below. Column = IFERROR('Table'[Custom], BLANK()) Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.
Mariusz7 years agoHi zilaifeng You can use if error like below. Column = IFERROR('Table'[Custom], BLANK()) Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.
Mariusz7 years agoHi zilaifeng You can use if error like below. Column = IFERROR('Table'[Custom], BLANK()) Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.
MariuszCommunity Champion7 years agoHi zilaifeng You can use if error like below. Column = IFERROR('Table'[Custom], BLANK()) Best Regards,MariuszIf this post helps, then please consider Accepting it as the solution.Please feel free to connect with me.
Related contentReplace NaN with blanks in Power QueryNaN ErrorReplace NaN with blank in measureNaN ErrorsNaN to replace with 0
