concatenate string aggregating dimension

[ValeriaBreve]

Hello!

I have a table in PowerBI looking like below:

Date	Time	Details
5/22/2024	8:00 AM	This is the 8 am text
5/22/2024	10:00 AM	This is the 10 am text
5/22/2024	12:00 PM	This is the 12 pm text
5/23/2024	8:00 AM	This is the 8 am text
5/23/2024	12:00 AM	This is the 12 am text

I need to aggregate the text by day, in a concatenation, like so:

Date	Details
5/22/2024	This is the 8 am textThis is the 10 am textThis is the 12 pm text
5/23/2024	This is the 8 am textThis is the 12 am text

I can't think of a good way of doing this... could you please put me in the right direction?

Thanks!

Kind regards

Valeria

[Arul · Accepted solution]

@ValeriaBreve ,

try this measure,

Details Measure = CONCATENATEX('Table','Table'[Details])

[ValeriaBreve]

@Arul thank you! That was so simple... I actually had a measure to start with, so I really did not think abput concatenatex. I have changed now to having a calculated column for the table and a measure for the concatenation and it works beautifully. Out of curiosity - is there a simple way to do it as well if instead of the calculated column I would still use a measure for "Details"? Thanks!