The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now
Hi,
Can anyone help me with this, please?
I have a column MCRType of type Table. The 5th row contains these values.
My requirement is I want those values to be comma-separated, but the split column in the power query editor is disabled for the MCRType column.
Solved! Go to Solution.
Thanks, @HotChilli for the reply.
So I created a custom column and wrote the code below and the new column got converted to list and I was able to extract values.
If i understand correctly you want to convert the table to a text field separated by commas.
So, add a custom column to create a list. This will be [MCRType][Value] . Then you can expand the list from the column header to extract values (choose comma as delimiter).
Thanks, @HotChilli for the reply.
So I created a custom column and wrote the code below and the new column got converted to list and I was able to extract values.