Forum Discussion
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-...
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], ", ")
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], ", ")
thank you so much!