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