How to extract value from Power BI list?

Help
1

How can I extract information from a “list” from the “materialQuantities” parameter

image
image1920×901 34.3 KB

2

Hey @joel_balvin ,

You can expand lists to new rows:

  1. Select the list column.
    1. Select the expand icon (Expand) in the column header of the structured column.
  3. Do one of the following:
    • To create a row for each list value, select Expand to New Rows.
    • To create a list of text values separated by a delimiter, select Extract Values.
  4. Select OK.

image
image1920×1355 300 KB

In order to keep this place focused on Speckle-related questions, I suggest checking out other resources first for any Power BI queries you may have. You’ll be surprised at how many answers you can find easily!