Forum Discussion

JoshuaBa's avatar
JoshuaBa
New Member
2 years ago
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...
Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
        replace_walmart = Table.ReplaceValue(
        your_table, 
        null,
        each [Retailer] = "Walmart",
        (v, o, n) => if n then null else v,
        {"Sales Units"}
    )
JoshuaBa's avatar
JoshuaBa
New Member
2 years ago

Just to confirm - there is no easy UI element for me to do this, and I have to use the editor /M code to accomplish this?

AlienSx's avatar
AlienSx
Super User
2 years ago

no UI, use Advanced Editor