Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 problem is that not even without the names and IBANs match, so I need to find out which sap lines do not match the bank's data.
The two filters I put up are the same, the only thing that each for each company in the group we have a docigo. I did it just to divide it by group company.
Solved! Go to Solution.
Hi Raymundo,
Acctualy I used the EXCEPT.
It worked.
Thanks anyway.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |