Forum Discussion

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost Partisan
2 years ago
Solved

concatenate string aggregating dimension

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 ...
Need Help
  • Arul's avatar
    Arul
    2 years ago

    ValeriaBreve ,

    try this measure,

     

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

Arul's avatar
Arul
Icon for Super User rankSuper User
2 years ago

ValeriaBreve ,

try this measure,

 

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

ValeriaBreve's avatar
ValeriaBreve
Icon for Post Partisan rankPost 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!