Compare 2 Datasets

[Nikesh007]

I have 2 different data sets, one from SAP and one from my internal system. Now I want to Compare which data has flown to SAP from My System to SAP. I have loaded both data sets in Power BI Desktop

[Anonymous]

Hi @Nikesh007 ,

Please try:

Create a calculated column:

Exists in SAP = IF(
     ISBLANK(LOOKUPVALUE('SAP_Table'[Column], 'SAP_Table'[Column], 'InternalSystem_Table'[Column])),
     "No",
     "Yes"
)

The purpose of this calculated column is to find rows in one table that do not exist in another table.

If you have any further questions please feel free to contact me.

Best Regards,
Yang
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[Nikesh007]

I have both the data in Excel and i have uploaded both file in BI Desktop, Since i am new to Power BI i need more elobrate Solution

[Musadev]

If you have 2 different files and loaded them into the PowerBI then mentioned steps in my other reply will help you to segregate your source files. 

[Musadev]

Open the Query Editor
select any table and then click on the Source in the Applied Steps section as mentioned in the below screenshot

As mentioned in M code oracle Database has a connection for this table.