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 A...
bcdobbs
Community Champion
Community ChampionReally 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:
I would like to put it to rows and next to each category (including " %") have a column with numbers.
| AAA in % | 25 |
| BBB in % | 2 |
| CCC in % | 54 |
| DDD in % | 56 |
| EEE in % | 6 |
Something like this