Forum Discussion
Filtering a table based on values within a nested table
Hi anktaggrwl,
Perhaps you could first expand the RecordType field, then, apply filters to [Business_Unit_c] and [Name] with OR logic.
After expanding all necessary columns, you can filter rows from UI.
Alternatively, you can directly input code like:
= Table.SelectRows(#"Changed Type", each [Category] = "A" or [Sales] = 52)
Best regards,
Yuliana Gu
While I know I could expand the field and then apply filters in the UI, I'm ideally looking to pass the filter in the initial call, as there are limitations in the number of rows I can pull back - so it would be more ideal to expand the RecordType field and filter for that AND filter in the business unit in one line... I'm just not sure how to write the expand and filter lines into one command.
Hi anktaggrwl,
Please see whether below thread helpful to you:
Filtering a Power Query Table Based on a Column That's a Table
By the way, for more professional advice about Power Query, you could post questions on Power Query forum.
Best regards,
Yuliana Gu