Use DAX measure to build IF ELSE function with column

[Anonymous]

Dear All,

I want to build a new measure (could also be a new column if this fits better), based on a IF ELSE function. 

Below you will see a small table, where one of the columns will be the condition in formula. 

The idea is the following:

I am looking for a formula containing the following:

IF column 'Advies Goederenklasse' = 'Parellel', then the outcome need to be 10%

IF  column 'Advies Goederenklasse' = 'Special', then the outcome need to be 5%

ELSE the outcome need to be 0

Thanks for any assistance in advance!

Kind regards,

[tamerj1 · Accepted solution]

Hi @Anonymous 

you can use

SWITCH (

TRUE ( ),

[Advies Goederenklasse] = "Parellel", 0.1,

[Advies Goederenklasse]= "Special" , 0.5,

0

)

[tamerj1 · Accepted solution]

Hi @Anonymous 

you can use

SWITCH (

TRUE ( ),

[Advies Goederenklasse] = "Parellel", 0.1,

[Advies Goederenklasse]= "Special" , 0.5,

0

)

[Anonymous]

Thanks for sharing.

Unfortunaltely it doesnt work with me. The column [Advies Goederenklasse] hasnt been recognised as a column name, even when I define the table name in front of it.

[tamerj1 · Accepted solution]

@Anonymous 

Make sure it is a column not a measure and double check the spelling