Filter rows in Query editor

[Anonymous]

Hello,

I want to create 2 new queries (query B, query C) from a single query (query A) in query editor. In query B I want to filter "male" (Gender="male) and on the other query (query C) I want to filter "female" (Gender="female").

Can you please tell me how I can do this in query editor using M language?

Many thanks,

MariosChr90

[MFelix · Accepted solution]

Hi @Anonymous,

I will give you the example for 1 table but just replicate the steps.

On the query editor

1 - On query A right click and choose reference (one with the clip icon) doing referece will allow you to update all your tables when you make changes to query A

2 - Filter out the column or columns you need or change or add columns as needed

Regards,

MFelix

[Anonymous]

Many thanks for your answer,

I still have an issue. I joined two tables and when use a column which belongs to the other table to filter out some rows it does not exclude the whole rows but keeps these rows and I get nulls in the value I filtered out. 

If this is not clear please let me know. 

Many thanks,

MariosChr90

[v-shex-msft]

HI @Anonymous,

So you join other tables and try to filter on original table to enable the filter effect to merge table, right?

If this is a case, I don't think it possible.(power query functions not support these operations)

If you filter on original tables, it can't analysis these source data and refresh merge table. You need to delete current steps and apply the filter before merge table.

Regards,

Xiaoxin Sheng

[Greg_Deckler]

Easiest way is just to copy query A to query B and C and in those queries, filter as necessary.