Forum Discussion
Compare 2 Datasets
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
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!