Forum Discussion
Helper IVcustom dax - contains
I am wanting to create a custom measure for this data. I basically want to say, if EventTypeName contains Bronze... print Bronze, if EvenTypeName contains Silver - print Silver, and if EventTypeName contains Gold, print Gold.
I am not sure how to do this. Thanks in advance,
There are 2 ways using DAX:
You should create a New Column not Measure
New Column =
SWITCH( TRUE(),
SEARCH( "Bronze", Table[EventTypename],,0) <> 0 , "Bronze",
SEARCH( "Silver ", Table[EventTypename],,0) <> 0 , "Silver ",SEARCH( "Gold ", Table[EventTypename],,0) <> 0 , "Gold",
"Other"
)OR
New Column = =IF (CONTAINS(Table[EventTypename],"Bronze"),"Bronze",IF (CONTAINS(Table[EventTypename],"Silver "),"Silver ",IF (CONTAINS(Table[EventTypename],"Gold"),"Gold")))
1 Reply
- themistoklis
Community Champion
There are 2 ways using DAX:
You should create a New Column not Measure
New Column =
SWITCH( TRUE(),
SEARCH( "Bronze", Table[EventTypename],,0) <> 0 , "Bronze",
SEARCH( "Silver ", Table[EventTypename],,0) <> 0 , "Silver ",SEARCH( "Gold ", Table[EventTypename],,0) <> 0 , "Gold",
"Other"
)OR
New Column = =IF (CONTAINS(Table[EventTypename],"Bronze"),"Bronze",IF (CONTAINS(Table[EventTypename],"Silver "),"Silver ",IF (CONTAINS(Table[EventTypename],"Gold"),"Gold")))