Forum Discussion
Solved
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. Yo...
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
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,
Lydia