How to convert rows to comma separated values in Power BI
In this blog, we will see how we can convert rows into comma-separated values in single rows using Power BI.
Import your table and go to transform data and remove empty or null rows if any.
Step 2: In-home section go to group by
Step 3: Group the table with the user column and select all rows in operation, give a name to your new column.
Step 4: Now go to the custom column section from add columns.
Step 5: Write the following query in the editor.
Table.Column( aggregate column name,”original column name”)
Hit ok and click on expand button and select extract values.
You can select the delimiter from the drop-down, here I have selected custom.
You can delete that aggregate column that was created before if you want to.
In this way, you can convert rows to comma-separated values in Power BI