Forum Discussion

harryli's avatar
harryli
Helper II
4 years ago
Solved

To integrate the data in one column

I would like to integrate each same first col data to be one row, like the following  NURSE_ID CARE_AIDE_ID ROOM_ID 11310 HCA001 A1009, A1010   May I ask is able to do this in P...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi harryli ,

     

    Please try this:-

    Measure= CONCATENATEX ( VALUES ( 'Table'), [Room_id], "," )

    BR,

    Samarth

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

Hi harryli ,

 

Please try this:-

Measure= CONCATENATEX ( VALUES ( 'Table'), [Room_id], "," )

BR,

Samarth

harryli's avatar
harryli
Helper II
4 years ago

Thanks, and it works.