Forum Discussion
Getting a specific row value from a list
After expending the column, you can use Merge Queries feature to add the column into original table. See if it helps.
You can refer to MS doc for the details.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Maybe you can try to extend list to rows first and then extract a specific value from it?
Yes, that's what I thought I'd try and do, but then how do I get that value as a column in the original data?
After expending the column, you can use Merge Queries feature to add the column into original table. See if it helps.
You can refer to MS doc for the details.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data
Thanks Jessica. This worked. I had to expand the column, then filter to a specific item in the list and then merge. But this looks like it's working.