Forum Discussion
Getting a specific row value from a list
Hi,
I've managed to get my data into the following table format:
I'm trying to add two new columns to this dataset based on row values that come from the highlighted column above. You'll notice it's a list of name value pairs per row. How do I go about extracting a specific value from the list for each row, and make this a new column in the main dataset?
Thanks.
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
5 Replies
garyhalb,
Which sample data do you store in the lists and which values would like to show in new column? If you want to create new column on the basis that check if a value is contained in the list, you can use List.Contains() function.
However, if you want to extract specific value from the list, you can firstly expand all values from the list to new rows, create a new column using Text.Contains() function to check if specific value exists in each row, then filter all the required rows.
Regards,
LydiaYes, 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
