How to Flag 7 extra row from 2 table by compare field name "SAP Item Code" ?

[admin11]

Hi All,

Sorry this is Excel questions.

I have 2 excel file both with same format , But there are 7 row extra from 14444row.xlxs

(A) I have file name = 1437row.xlxs :-

https://www.dropbox.com/s/5qkllu0a2kgz3ka/1437row.xlsx?dl=0

(B) I have file name =1444row.xlxs :-

https://www.dropbox.com/s/yiye5a8p9ng0bgv/1444row.xlsx?dl=0

Can some can share me the step to list the 7 (1444-1437)) extra row from file 1444row.xlxs Base on Row B = "SAP ITEM CODE"

Paul Yeo

@VijayP 

@Ashish_Mathur 

in case you happen to read my post , hope you can advise me.

[v-rongtiep-msft · Accepted solution]

Hi @admin11 ,

Please refer to my pbix file to see if it helps you.

Create a measure.

Measure 2 = CONTAINS('Table (2)','Table (2)'[item code 1],MAX('Table'[item code]))*1

Then filter the data. Add the above measure to the Visual Filter of Table 1 and set to  = 0 and click apply. It will update automatically 

Please keep the word spacing and formatting consistent.

If I have misunderstood your meaning, please provide your desired output with more details.

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @admin11 

If Item code is the unique value for both excel
Please run MATCH() function to compare which item code in 1444 excel is not present in 1437 excel

If Item code is not unique value, then you need to create quique value by CONTAINATE different col then
Please run MATCH() function to compare which item code in 1444 excel is not present in 1437 excel

If you have any question, please keep posted
If solve your requirement, please mark this answer as SOLUTION
If this comment helps you, please LIKE this comment/Kudos

[lbendlin]

Where do you want this solved, in Power Query or in DAX?  in DAX you would use a simple EXCEPT() call, but in Power Query it is a little more convoluted.

[admin11]

@lbendlin 

Thank you very much for your reply to my quary.. since PQ is complicate to solve i will go ahead with DAX. Hope you can help me.

Paul