Forum Discussion
Gurpreetsingh1
Helper I
Helper IFind Mismatch orders b/w Salesforce data and SAP dat
Hi guys, Hope your are doing well. I have sales orders data sets. One is from Salesforce and 2nd is from SAP. Both are sales order datasets. Now I want to find mismatch of SAP orders with Salesf...
Thankyou, lbendlin, Ashish_Mathur, rohit1991 for your response.
Hi Gurpreetsingh1,We appreciate your inquiry through the Microsoft Fabric Community Forum.
Please find attached the screenshot and the PBIX file that may assist in resolving the issue:If you find our response helpful, we kindly request you to mark it as the accepted solution and provide kudos. This will aid other community members who may encounter similar queries.
Thank you.
lbendlin
Super User
Super UserNone of the above. Use EXCEPT() in DAX to find the differences.
Gurpreetsingh1But want to show both datasets in a single table and then give filters for every mismatch like Order mismatch, region mismatch, product code mismatch.