To integrate the data in one column

[harryli]

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 Power Bi?

[Samarth_18 · Accepted solution]

Hi @harryli ,

Please try this:-

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

BR,

Samarth

[harryli]

Thanks, and it works.