Forum Discussion

djk123's avatar
djk123
New Member
3 years ago

Concatenating comments based on unique values

Hello, I am relatively new to PowerBI so apologies the question is not framed well.   I have the following dataset (simplified for ease). I want to combine the comments where the city and measur...
CONCATENATEX
DAX
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper User
3 years ago

Hi,

Please check the below picture and the attached pbix file.

 

 

 

Expected result CC =
CONCATENATEX (
    FILTER (
        'Table',
        'Table'[City] = EARLIER ( 'Table'[City] )
            && 'Table'[Measure] = EARLIER ( 'Table'[Measure] )
    ),
    'Table'[Comments],
    ", "
)