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.