Forum Discussion
concatanate a column by row
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>)
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.
3 Replies
- Fowmy
Super User
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>)) 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.
