Forum Discussion
Comparing Two Sales Tables
Hi Gurpreetsingh1 ,
Thank you for reaching out to the fabric community. We have reviewed your scenario and implemented the logic to classify the records based on Product Code and Amount comparisons between the Salesforce and SAP tables.
FYI:
Based on our testing, the logic is working as expected. Please refer to the Match Type column in the result to view the classification.
For better understanding, I’ve attached the PBIX file. Kindly go through it, it demonstrates the logic and output based on your scenario.
Thank you for your response, m4ni & Deku .
If my message helped solve your issue, please mark it as Accepted Solution. If it was helpful, consider giving it a Kudos.
I would union them. Then group by all three columns, and count the number of rows. Those with a count of 2 are the same between the two sources. Those with a 1 only exist in one source or the amount differences between sources.