Forum Discussion
Compare 2 Excel Files
Hi everybody! I have 2 Excel Files. File A and File B.
Both have the same column name and same row number (about 8000+).
Product Name and Store ID are the same, but the value of other columns may be different.
Could I use the PowerBI to generate the difference report?
I really would appreciate an answer!
The report I want to generate is like the following, the difference may be highlighted.
3 Replies
Anonymous , In Power Query merge left anti join, and Except in DAX can give you a new table with difference,
Other wise you have create common tables and compare values in measures to find differnece
Hi amitchandak Thank you very much! Could you give me more details for "create common tables and compare values in measures to find differnece", I tried but was not successful.
amitchandak It will be appreciated if you could tell how to realize my following requirement. I merged the 2 tables in to Merge table, and want to highlight the difference by comparing table A [Product_Origin] vs table B [Product_Origin],
table A [Transaction_Time] vs table B [Transaction_Time] ,and other mutiple columns like the screenshot.
