Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
in case you happen to read my post , hope you can advise me.
Solved! Go to 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.
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.
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
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.
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