Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Group list into one cell

Hello,   I am trying to change the table below :   To look like this: Material Work Ctr 9266802471 TBD24 TBE22 TBE24   Basically have all "Work Ctr" for the material 926680247...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    You can create a calculated column as below to get it:

    Column = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[Material] = EARLIER ( 'Table'[Material] ) ),
    'Table'[Work Ctr],
    " ",
    'Table'[Work Ctr], ASC
)

    Best Regards

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous ,

You can create a calculated column as below to get it:

Column = 
CONCATENATEX (
    FILTER ( 'Table', 'Table'[Material] = EARLIER ( 'Table'[Material] ) ),
    'Table'[Work Ctr],
    " ",
    'Table'[Work Ctr], ASC
)

Best Regards