Forum Discussion

Nikesh007's avatar
Nikesh007
New Member
2 years ago

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

Need Help

4 Replies

  • Musadev's avatar
    Musadev
    Resolver III
    2 years ago

    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.

     

  • Nikesh007's avatar
    Nikesh007
    New Member
    2 years ago

    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's avatar
      Musadev
      Resolver III
      2 years ago

      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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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!