Forum Discussion
Solved
Return multiple values from lookup
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 , Use a measure
concatenatex(Table, Table[Value], " ,")
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
2 Replies
UBComma , Use a measure
concatenatex(Table, Table[Value], " ,")
Concatenate Text- Measure, DAX Table, and Power Query Table: https://youtu.be/xAh3tz1qo24
amitchandak thank you!
