How do I combine 3 columns together in PowerBI

[WestWinter]

Was wondering how should I combine the 3 columns of value, unit, comments together as a measure or column, so that I could use it in a table/matrix?

Thanks

From:

Name	Value	Unit	Comments
Test	50	%
Test2	20	%	Executed
Test3	30	%

To:

Name	Value	Unit	Comments	Combined
Test	50	%		50%
Test2	20	%	Executed	20% Executed
Test3	30	%		30%

[Pragati11]

Hi @WestWinter ,

If you don't want to create a column, but want to go with the option of creating a measure (which I usually prefer),

you can create a measure as below:

combinedValue = 
    CONCATENATE(
        SELECTEDVALUE ( dummyData[Value] ) & " ",
        CONCATENATE(
            SELECTEDVALUE( dummyData[Unit]) & " ",
            SELECTEDVALUE( dummyData[Comments])
        )
    )

This will end up giving you following result:

You can modify the delimiter as per your requirement in the above DAX expression for the measure.

Thanks,

Pragati

[KamilSzpyrka · Accepted solution]

To create column please try CONCATENATE as below:

Combined = CONCATENATE([Value], CONCATENATE([Unit], [Comments]))

or if you want additional space between units and comments:

Combined = CONCATENATE([Value], CONCATENATE([Unit]&" ", [Comments]))

[amitchandak]

@WestWinter , Create a new column like

Column = [value] &"-" &[unit] &"-" & [comments]