Forum Discussion
anktaggrwl
8 years agoKudo Collector
Filtering a table based on values within a nested table
I have an events object that I'm querying on salesforce that has the following format: Id Business_Unit__c RecordType ABC123 XYZ Value ABC124 SYW Value ABC125 SYW Value ABC...
anktaggrwl
8 years agoKudo Collector
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.
v-yulgu-msft
8 years agoMicrosoft Employee
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