Forum Discussion
Solved
Clear all values in column
Hi everyone, I have a simple task but I cannot figure out how to do this. I have two columns, one a Retailer column that has dozens of retailers, and a second column that has sales units I e...
replace_walmart = Table.ReplaceValue( your_table, null, each [Retailer] = "Walmart", (v, o, n) => if n then null else v, {"Sales Units"} )
replace_walmart = Table.ReplaceValue(
your_table,
null,
each [Retailer] = "Walmart",
(v, o, n) => if n then null else v,
{"Sales Units"}
)