Forum Discussion

Baconbomb's avatar
Baconbomb
Icon for Helper I rankHelper I
8 years ago
Solved

Change value based on value in other column

Hi. I have a column where i want to change the value IF its blank or # and if the value in a different column is NOT "x" or "y" or "z"   To explain it a little better. So the column i want to cha...
Need Help
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    Baconbomb,

     

    You may refer to the following DAX that adds a calculated column.

    Column =
IF (
    Table1[Column1] IN { "", "#" }
        && NOT ( Table1[Column2] IN { "x", "y", "z" } ),
    TRUE (),
    FALSE ()
)
Baconbomb's avatar
Baconbomb
Icon for Helper I rankHelper I
8 years ago

Missed them. Now it works.

 

Thanks for the help.