Forum Discussion

StoryofData's avatar
StoryofData
Icon for Helper III rankHelper III
3 years ago
Solved

Rows to List

Hello,    How do I convert my table into a list based on selected values?   This is what I have  Identification Number Category All Other columns A-123 Apple   A-123 Mango   A-...
Need Help
Tips and Tricks
Tutorial Requests
  • vicky_'s avatar
    vicky_
    3 years ago

    If this is in DAX, you can use the CONCATENATEX function to combine; something like:

    CategoryCombined = CONCATENATEX(CALCULATETABLE('Table', ALLEXCEPT('Table', 'Table'[Identification Number])), 'Table'[Category], ", ")

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

If this is in DAX, you can use the CONCATENATEX function to combine; something like:

CategoryCombined = CONCATENATEX(CALCULATETABLE('Table', ALLEXCEPT('Table', 'Table'[Identification Number])), 'Table'[Category], ", ")