Forum Discussion
OsmanEmi
5 years agoFrequent Visitor
Using a measure on a string based column
Hi,
I have a data set like the one below.
I'm trying to write a measure so that the measure outputs a corresponding text when it compares the values in the column.
I know it would be easier doing a calculated column however I can't modify dataset unfortunately.
for example
if the column displays "1" i would like to output London or if it displays "2" Paris and so on.
Please note although the column is a integer the data type is string
| Location |
| 1 |
| 2 |
| 3 |
| 4 |
| 5 |
Measure := switch(SELECTEDVALUE('Table'[Column]),"1","London","2","Paris","Elsewere")
1 Reply
- lbendlinSuper User
Measure := switch(SELECTEDVALUE('Table'[Column]),"1","London","2","Paris","Elsewere")