concatanate a column by row

[Anonymous]

I am trying to concatenate a column of refernece numbers by load number. I tried doing a simple concatenate formula but it concatenated the entire column into one row. I need just one row at a time concatenated not the entire column. Below is what i used. 

CONCATENATE(<text1>, <text2>)

[v-yetao1-msft · Accepted solution]

Hi @Anonymous 

Please correct me if I wrongly understood your question.

Since you did not provide accurate data, I am here to provide a simple example .You can refer to it .

Original data:

And then transpose the table in Query Editor .

Create a measure with CONCATENATE dax. Because CONCATENATE only supports two parameters, when you have multiple columns, you can use nested .

Measure = CONCATENATE(MAX('Table'[Column1]),CONCATENATE(MAX('Table'[Column2]),MAX('Table'[Column3])))

The effect is as shown:

Best Regards

Community Support Team _ Ailsa Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

@Anonymous 

Not clear what you want to do. Please be more specific.

[Fowmy]

@Anonymous 

It depends where your formula is, if you are creating a calculated column in a table then the above will work and go one row at a time but if you want to create a measure then, include the column value within an aggregator like

Measure = CONCATENATE( MAX(<text1>), MAX (<text2>))