Summarize and Concatenate or & " - "

[cristianml]

Hi,

I want to return a single column with a concatenation of two columns and " - "  between them :

First I have to summarize 5 different tables. In the screenshot below I have 2 but I have 5

I was trying to combine summarize with concatenate or & but I couldn't .

EXAMPLE :

Hope you can help me.

Thanks,

[v-rongtiep-msft]

Hi @cristianml ,

Please select the 2 columns.

Click add column>> merge columns.

If I have misunderstood your meaning, please provide more details with your desired output.

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.

[amitchandak · Accepted solution]

@cristianml ,

You use Addcolumns

addcolumns(v2, "combine", [Master Client#] & "-" & [Client Name])

You can use selectcolumns to reduce the column if you want

https://docs.microsoft.com/en-us/dax/selectcolumns-function-dax