Forum Discussion

Helper 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

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

Helper I

8 years ago

v-chuncz-msft

Maybe im missing something or its the way my data is formulated but here is the "translation" of your formula that i made and i get an error

Country =
 IF(
     'All trafik Nat, roam och data'[Land/Country]={"";"#"} 
        && NOT 'All trafik Nat, roam och data'[Call Descr]={"I utländska 
        nät";"GPRS/3G i utlandet";"Till fastnät utomlands";"SMS till utlandet";"Till 
        mobil utomlands"};
    "Sweden";
    'All trafik Nat, roam och data'[Land/Country])

A table of multiple values was supplied where a single value was expected.

v-chuncz-msft