topic Extract data from List value column in DAX Commands and Tips

Extract data from List value column

Anonymous — Thu, 08 Jun 2023 12:52:53 GMT

Hi All,

I have a query which has a column name "Components" and it has List values in it . I want to extract the data from this column so it gets stored in a new column in the query.

Basicaly I want to extract the data in "name" attribute . How this can be done? Any help will be much appreciated.

Thanks

Re: Extract data from List value column

ppm1 — Fri, 09 Jun 2023 01:55:42 GMT

That looks like a record. Try

= Components2{0}[name]

Pat

Re: Extract data from List value column

Anonymous — Fri, 09 Jun 2023 08:39:23 GMT

Hi ppm1 , It's a list. Please see below more screenshots.

When you click on List then below screen comes up:

Re: Extract data from List value column

ppm1 — Sat, 10 Jun 2023 11:14:06 GMT

In the colulmn header, click on the double arrow expand button and "expand to new rows". You should then have a column of Records. Click on the expand button on that column and choose only the name field.

Pat

Re: Extract data from List value column

Anonymous — Tue, 13 Jun 2023 02:37:07 GMT

Hi Anonymous ,

This is a blog on how to extract values from records and lists, I believe it will be helpful to you.

Extract Values From Records And Lists In Power Query - Master Data & AI Skills (enterprisedna.co)

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.