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 c...
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
Not clear what you want to do. Please be more specific.