Forum Discussion
virendrajadhav1
Helper I
Helper INeed 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...
you may use the function of Table.TransformColumns, instead of Table.TransformColumnNames
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
Community Champion
Community Championif 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 _)
virendrajadhav1Helper I
Helper IDaniel, Thanks much. Really appreciate your help. 🙂