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 b...
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
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.