Forum Discussion
Measure to concanate a column with string
Hello,
I have a column (with categories)
Example
| AAA |
| BBB |
| CCC |
| DDD |
| EEE |
And i would like to create a measure that adds a string after each line. E.g. "in %", like a sufix
| AAA in % |
| BBB in % |
| CCC in % |
| DDD in % |
| EEE in % |
Is it possible?
Thank you
9 Replies
- bcdobbs
Community Champion
Hi,
I think you want a calculated column rather than a measure.
Following DAX will do what you need:
New Column = Table[Original Column] & " in %"
smpa01Anonymous the measure would be
Measure = MAX(tbl[c1])&" in %"
- smpa01
Anonymous this will add that prrfix to each string
- bcdobbs
Really depends what you want to use the measure for. For example I don't think you can slice by a measure or use it in a row or column field.
You could enable the direct query for power bi datasets in the preview features and create a composite model which will let you add a column:
Hi Anonymous ,
It seems the connection mode you are using is live connection. So until now, this is the only way you can use to add a string.
You add a text string. So the format cannot be converted to data .
- Create a measure.
Measure = "in %" &MAX('Table'[num])Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
