Forum Discussion

tracyhopaulson's avatar
tracyhopaulson
Icon for Resolver I rankResolver I
6 years ago
Solved

if statement custom column

I have a column "Item" that I would like to find all values start with "SK" or "78", then insert a text "Do Not Use" to the custom column, otherwise, carry the values from column Item over as is.  Ca...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi tracyhopaulson 

     

    I would create  a column

    _new_column = IF(LEFT([column],2) IN {"SK","78"}, "Do Not Use",[column])

  • tracyhopaulson's avatar
    tracyhopaulson
    Icon for Resolver I rankResolver I
    6 years ago

    Ajinkya369  attaching image of data and the result I would like to achieve.  Need help with Dax formula or custom column formula please.  Thank you.