Filter a table with nested columns directly in the table

[francisthe63]

Hello, 

I have 2 questions

1/ I have a table when i must expand column and expand list to filter a specific value, but i have problem of performance. If we filter directly in the first step can i optimize the performance ?

2/ How to do this ? 

I have many steps with list then convert to table then record then list then record then list etc ... 

Here is the image of my workflow 

 In the end, i filter field = status 

So my workflow is : My list ->Convert to table -> Column of Records -> Column of Records-> Column of Lists -> Column of Records --> Column of Lists-> Column of Records --> Field = Status

How can i filter field = status directly before expand list and record etc  ...  ?

Because i have a very large numbers of rows when i expand all fields

Thank you in advance 

[ManuelBolz]

Hello @francisthe63,

Let me guess: your data source is a complex JSON file or API? Would it be possible to make your M code available to the community to better evaluate whether something can be optimized?

Best regards from Germany
Manuel Bolz

🟦Follow me on LinkedIn
🟨How to Get Your Question Answered Quickly
🟩Fabric Community Conference
🟪My Solutions on Github