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 essentially want to clear all values that show under the Sales Units column, but only for the retailer Walmart (all other retailers are unchanged)

I have already filtered the rows to select just Walmart, but I cannot figure out on how to clear the values.

 

I have the following limitations:

 

-I do not want to create a new column

-I cannot use Replace Values as there are thousands of unique values.

 

I looked around and it was advised to use the * symbol in the Replace Values prompt, but it seems it only allows numeric values.

 

Can anyone advise?

 

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"}
    )

4 Replies

  • AlienSx's avatar
    AlienSx
    Super User
    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?

  • 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.