Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Use DAX measure to build IF ELSE function with column

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,

  • Hi Anonymous 

    you can use

    SWITCH (

    TRUE ( ),

    [Advies Goederenklasse] = "Parellel", 0.1,

    [Advies Goederenklasse]= "Special" , 0.5,

    0

    )

  • tamerj1's avatar
    tamerj1
    4 years ago

    Anonymous 

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

3 Replies

  • tamerj1's avatar
    tamerj1
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

    you can use

    SWITCH (

    TRUE ( ),

    [Advies Goederenklasse] = "Parellel", 0.1,

    [Advies Goederenklasse]= "Special" , 0.5,

    0

    )

    • Anonymous's avatar
      Anonymous
      Not applicable

      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's avatar
        tamerj1
        Icon for Community Champion rankCommunity Champion

        Anonymous 

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