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_IDCARE_AIDE_IDROOM_ID
11310HCA001A1009, A1010

 

May I ask is able to do this in Power Bi?

 

Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    Hi harryli ,

     

    Please try this:-

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

    BR,

    Samarth

2 Replies

  • Samarth_18's avatar
    Samarth_18
    Community Champion
    4 years ago

    Hi harryli ,

     

    Please try this:-

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

    BR,

    Samarth