Forum Discussion
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
)
Anonymous
Make sure it is a column not a measure and double check the spelling
3 Replies
- tamerj1
Community Champion
Hi Anonymous
you can use
SWITCH (
TRUE ( ),
[Advies Goederenklasse] = "Parellel", 0.1,
[Advies Goederenklasse]= "Special" , 0.5,
0
)
- AnonymousNot 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
Community Champion
Anonymous
Make sure it is a column not a measure and double check the spelling