Forum Discussion
gauravnarchal
Post Prodigy
Post ProdigyMeasure - IF Condition for Text
Hello - I need your help to create a measure to find the text in the table and return a value based on the condition.
Condition - If "Table Exchange" has a value True return a value “Discounted” else Blank (No Value)
Thanks
Gaurav
| Exchange |
| FALSE |
| TRUE |
| FALSE |
| FALSE |
| FALSE |
| FALSE |
| TRUE |
| TRUE |
| TRUE |
| TRUE |
| FALSE |
| FALSE |
| FALSE |
| TRUE |
gauravnarchal
For a measure:Measure 1 = IF( SELECTEDVALUE(Table[Offer is Selected]), "Discounted" )If you need a column then,
Column 1 = IF( Table[Offer is Selected], "Discounted" )
2 Replies
smpa01Community Champion
Column = if('Table 1 (3)'[Exchange]=TRUE(),"Discounted",BLANK())- Fowmy
Super User
gauravnarchal
For a measure:Measure 1 = IF( SELECTEDVALUE(Table[Offer is Selected]), "Discounted" )If you need a column then,
Column 1 = IF( Table[Offer is Selected], "Discounted" )