topic Measure to concanate a column with string in DAX Commands and Tips

Measure to concanate a column with string

Anonymous — Sat, 04 Dec 2021 14:13:50 GMT

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

Re: Measure to concanate a column with string

bcdobbs — Sat, 04 Dec 2021 14:21:31 GMT

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 %"

Re: Measure to concanate a column with string

Anonymous — Sat, 04 Dec 2021 14:36:39 GMT

I have a limited dataset, I canť see data or add any additional columns into tables. Only measures is possible to create.

So I´m curious if this works for any measures?

Re: Measure to concanate a column with string

smpa01 — Sat, 04 Dec 2021 14:39:38 GMT

Anonymous the measure would be

Measure = MAX(tbl[c1])&" in %"

Re: Measure to concanate a column with string

Anonymous — Sat, 04 Dec 2021 14:44:52 GMT

That would only add the string to the last line of the column not?

Re: Measure to concanate a column with string

bcdobbs — Sat, 04 Dec 2021 14:55:47 GMT

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:

https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services

https://m.youtube.com/watch?v=g-nRxDVt3To

Re: Measure to concanate a column with string

Anonymous — Sat, 04 Dec 2021 15:02:28 GMT

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

Re: Measure to concanate a column with string

smpa01 — Sat, 04 Dec 2021 15:02:46 GMT

Anonymous this will add that prrfix to each string

Re: Measure to concanate a column with string

Anonymous — Fri, 31 Dec 2021 05:35:45 GMT

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.

Re: Measure to concanate a column with string

Anonymous — Wed, 15 Dec 2021 02:24:26 GMT

Hi Anonymous ,

I have modified my answer. Please check if your needs are met.

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.