Forum Discussion

virendrajadhav1's avatar
virendrajadhav1
Helper I
3 years ago
Solved

Need help to replace NaN values

Hi, I am trying to replace NaN values in my table with following M code #"remove_nan" = Table.TransformColumnNames(#"Rounded Off2",{{"q_to_p", each if Number.IsNaN(_) then 0 else _,type numbe...
Need Help
Show and Tell
  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    you may use the function of Table.TransformColumns, instead of Table.TransformColumnNames

  • wdx223_Daniel's avatar
    wdx223_Daniel
    3 years ago

    if you want to remove the value from columns regardless of column names, can try this code

    =Table.TransformColumns(PreviousStepName,{},each if _ is number and Number.IsNaN(_) then 0 else _)

wdx223_Daniel's avatar
wdx223_Daniel
Community Champion
3 years ago

you may use the function of Table.TransformColumns, instead of Table.TransformColumnNames

  • virendrajadhav1's avatar
    virendrajadhav1
    Helper I
    3 years ago

    Daniel, Thank you. It worked. 
    One added question, if I have to add another seperate line of code which removes "Infinity" from the coloums, how should I do that? 

    • wdx223_Daniel's avatar
      wdx223_Daniel
      Community Champion
      3 years ago

      if you want to remove the value from columns regardless of column names, can try this code

      =Table.TransformColumns(PreviousStepName,{},each if _ is number and Number.IsNaN(_) then 0 else _)

      • virendrajadhav1's avatar
        virendrajadhav1
        Helper I
        3 years ago

        Daniel, Thanks much. Really appreciate your help. 🙂