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"}
    )
Elcin_7's avatar
Elcin_7
Helper I
2 years ago

Hi, 

 

You can create a measure and use the Dax formula below. You need to change the formula with the name of your relevant table and column.

replace = SUMX(tablename, IF(tablename[retailler] = "Walmart", 0, tablename[unitprice]))
 
There are other options but you need to create a column to do them.