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