Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Post Partisan
2 years ago
Solved

concatenate string aggregating dimension

Hello!

I have a table in PowerBI looking like below:

 

DateTimeDetails 
5/22/20248:00 AMThis is the 8 am text
5/22/202410:00 AMThis is the 10 am text
5/22/202412:00 PMThis is the 12 pm text
5/23/20248:00 AMThis is the 8 am text
5/23/202412:00 AMThis is the 12 am text

 

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

DateDetails
5/22/2024This is the 8 am textThis is the 10 am textThis is the 12 pm text
5/23/2024This 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

 

Need Help

2 Replies

  • Arul's avatar
    Arul
    Super User
    2 years ago

    ValeriaBreve ,

    try this measure,

     

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

    • ValeriaBreve's avatar
      ValeriaBreve
      Post Partisan
      2 years ago

      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!