Return multiple values from lookup

[UBComma]

Does anyone know if there is a way to lookup a value from one table and return multiple values concatenated together like shown in the [Result] column of the 'Result Table' below?

Lookup Table

Item	Value
Item #1	Red
Item #1	Large
Item #2	Yellow
Item #2	Small

Result Table

Item	Result
Item #1	Red; Large
Item #2	Yellow; Small

[UBComma]

@amitchandak thank you!

[amitchandak · Accepted solution]

@UBComma , Use a measure

concatenatex(Table, Table[Value], " ,")

Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24