Replace all NULLs with 0 in a table with multiple columns except in 1st column

El Cid

Member
Joined
Aug 22, 2016
Messages
52
Reaction score
0
Points
6
Location
Greenville, SC
Excel Version(s)
Excel 2016
#"Replaced Value" = Table.ReplaceValue(#"Sorted Rows1",null,0,Replacer.ReplaceValue,List.Transform(List.Skip(Table.ColumnNames(#"Sorted Rows1"),1))),


This ain't workin'. I would appreciate any guidance.
 
Drop the List.Transform portion out:

Code:
#"Replaced Value" = Table.ReplaceValue(#"Sorted Rows1",null,0,Replacer.ReplaceValue,List.Skip(Table.ColumnNames(#"Sorted Rows1"),1)),
 
Back
Top