Forum Discussion

zilaifeng's avatar
zilaifeng
Frequent Visitor
7 years ago
Solved

Replacing 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!

Need Help
  • Mariusz's avatar
    Mariusz
    7 years ago

    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.
    Mariusz Repczynski

     

2 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    7 years ago

    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.
    Mariusz Repczynski

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thanks for the quick solution.