Forum Discussion

rgimenez's avatar
rgimenez
Helper I
4 years ago
Solved

Compare columns

Hy guys, I need to check the inconsistency of the data between these two tables: the first is the bank data with the respective IBAN and in the other the data we have in SAP and its IBAN. The prob...
Need Help
  • rgimenez's avatar
    rgimenez
    4 years ago

    Hi Raymundo,

     

    Acctualy I used the EXCEPT.

    It worked.

     

    Thanks anyway.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Are these tables related? If they are you can create a calculated column with RELATED() to compare two columns or even merging them in Power Query and creating a conditional column.