Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Comparing Two Columns from different tables and list out un-matched records.

Dear experts, Please help me by providing the solution to the query: by comparing two columns of the same kind and listing out the unmatched records. The logic should read "common company" and "comm...
Need Help
djurecic's avatar
djurecic
Icon for Super User rankSuper User
3 years ago

Hi Anonymous ,

 With EXCEPT, you need to use the table name, not a selectedvalue from a table.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi@dj,

    Tried as you mentiones, but need to compare two columns in in different tables with EXCEPT. 

     


    Can you please eloborate with query for comapring two columns.

    Thanks,

    Sareen

    • v-yinliw-msft's avatar
      v-yinliw-msft
      Icon for Community Support rankCommunity Support
      3 years ago

      Hi Anonymous ,

       

      You can try this method:

      New a table:

      Table =
UNION ( EXCEPT ( 'Table2', 'Table1' ), EXCEPT ( 'Table1', 'Table2' ) )

      The result is:

      Result = FILTER('Table','Table'[Line Number] <> BLANK())

       

      Hope this helps you.

      Here is my PBIX file.

       

      Best Regards,

      Community Support Team _Yinliw

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        Hi v-yinliw-msft ,
        Thanks for your inputs. UNION  and EXPECT are work, when both the tables having same number of columns. Coming to real scenario, I have two tables which don't have same numner of columns and they are in directly mapped with DIM table with common column. Can you please provide solution on this case like by creating variables. And in the output tables, only single column can see for missing line Number for a sing order with comapny.
        Like: 

        CompanyOrderResult Column
        PBLG319816Missing Lines : 4, 5

         

        Appriciate if can provide the solution.

        Thanks,

        Sareen