Transpose single column in dax or power query

user_7662484 0
Viewed 2644

I have a required where i need to transpose specific column using Powerbi calculated column /power query

1 Dressing
1 Transferring
2 Bathing
2 Dressing
3 Transferring

**Is there anyway to transpose it to the following:**

1 Bathing Dressing Transferring
2 Bathing Dressing
3 Transferring
dax powerbi powerquery
1 Answers

If Transferring is there for ID 1 is a mistake, you can perform some transformation in Power Query Editor to achieve the required output.

Let, your table looks as below-

enter image description here

Now follow this below steps-

Step-1: Apply a GROUP BY on ID column as shown below-

enter image description here

Step-2: Create a custom column as below-

enter image description here

Step-3: Now extract the values from the new Custom column as below-

enter image description here

Here is the final output. You can remove column grouped_data at the end.

enter image description here

user_36523450
Related