Forum Discussion

Gurpreetsingh1's avatar
Gurpreetsingh1
Helper I
1 year ago
Solved

Comparing Two Sales Tables

Hi Guys, Hope you are doing well. I am working on a report in this report I have two  sales tables one is from SAP and Another is from Salesforce. And I have find match mismatch between both of them...
Data Protection
General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    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.

     

     

     

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi Gurpreetsingh1 ,

I hope the previous response was helpful. For better understanding, please check the attached PBIX file.

If this resolves your query, kindly mark it as an accepted solution  it will help other community members facing a similar issue.

 

Thanks.