Awesome! Thank you!

Lock it in!

Excellent video. Question: what’s the advantage of this method vs the conventional method?

@basensei8699

Жыл бұрын

Hey Ron! the conventional method when you expand first then apply the filter will slow down your queries quite a bit especially when the workbooks are massive (MB wise). So with this approach you kind of side step that issue. I by default apply the method in this video to all my queries when reading workbooks from folders.

=> 4:38 I've noticed writing you =true for List.Contains function in many vidoes. If we just put "value" as any that we want to find in the second parameter, that would still work.

@basensei8699

5 ай бұрын

that's awesome! i didn't know that :)

Is this possible using Table.TransformColumns instead of AddColumn, so there's not an extra clean-up step?

@basensei8699

6 ай бұрын

yes indeed

Hi! I have an question about the file format. I am getting data from Oracle database, that is massive data and I am working with Power BI, so my source file is (Pbix). Is power bi format supported for this kind of filtering before expanding?! I should mention that I should filter before expanding, because I have lots of nested tables. You are using Excel file, so are using Excel wookbook formula, but my file is Power BI. Please, guide me through this process.

How can I do full outer join without duplicate ??