Forum Discussion
Filter table in Power Query based on two columns
Hello guys, trying to figure out what I though is an easy task so I can streamline my queries. I have two colums I want to use to filter Column 1: File name: 2021 Consolidation.xlsm 20...
I'm a bit late to the party, but I have a different take - it requires a new column but depending on how big your model is, it might be OK.
Create a concatenation of column 1 and 2.
This creates strings like:
unconsolidated Sales Intercompany
unconsolidated Cost Intercompany
In the new column, you can filter for those strings, using the usual Power Query column filter function (no actual coding required).
Cheers