Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Filter rows in Query editor

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 t...
Need Help
  • MFelix's avatar
    MFelix
    8 years ago

    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's avatar
Anonymous
Not applicable
8 years ago

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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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