Forum Discussion

israabuhasna's avatar
israabuhasna
Helper I
6 years ago
Solved

Filtering table based on another table conditions in Power Query without merging tables

Hi,   I'm trying to filter a table based on another table column in Power Query. I do not want to merge the two tables to create a whole new table. Example: I have two separate tables, 1 with the l...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    6 years ago

    Hi israabuhasna ,

    By my tests and research, you could try the power query below.

    Table.SelectRows(#"Changed Type", each List.Contains(#"Table 2"[BuildingID],[BuildingID]))

    Here is the output.

    In addition, you also could download my test file and do a research.

    Best  Regards,

    Cherry

     

    Filtering table based on another table conditions.pbix37 KB
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

 

maybe this works without the if-condition:

 

Table.SelectRows(#"Filtered Rows1", each List.Contains(#"SiteSolutions T_BUILDINGS"[BUILDING_KEY],[BUILDING_KEY]))

 

I am trying to figure out this filtering technique as well for some stats at work.

 

My goal is to load a query based on the results from a pre-loaded first query's column.

 

Best

  • israabuhasna's avatar
    israabuhasna
    Helper I
    6 years ago

    No it won't work because some sources have the same BuildingID and I need to filter only for the source 'S2' since Table2 is only for source S2. Thank you for the response though.

    • v-piga-msft's avatar
      v-piga-msft
      Resident Rockstar
      6 years ago

      Hi israabuhasna ,

      By my tests and research, you could try the power query below.

      Table.SelectRows(#"Changed Type", each List.Contains(#"Table 2"[BuildingID],[BuildingID]))

      Here is the output.

      In addition, you also could download my test file and do a research.

      Best  Regards,

      Cherry

       

      Filtering table based on another table conditions.pbix37 KB
    • HotChilli's avatar
      HotChilli
      Community Champion
      6 years ago

      I think this version works.  Please test with your data and field names

       Table.SelectRows(#"Changed Type", each if [Source] = "S2" then  List.Contains(#"Table 2"[BuildingID], [BuildingID]) else true)