Power Query Challenge: Approximate Match in Power Query (PQC07)

To Subscribe to the English Channel:
/ @aaaexcelenglish
----------------------------------------------------
#excel #powerquery #msexcel #exceltutorial
----------------------------------------------------
Visit the website: www.aaa-power.net
----------------------------------------------------
To download excel file:
drive.google.c...
----------------------------------------------------
Emial your solution to: [e-mail]
Please use the following subject: PQC07 Solution
----------------------------------------------------
To subscribe:
/ @aaaexcel
----------------------------------------------------
To follow on Facebook:
/ excelispower
----------------------------------------------------
To follow on LinkedIn:
/ amratef

[@kevinshoemaker1466]

I just found your English site. Thank you! Thank you!

[@roywilson9580]

Nice to see you back with another challenge. I noticed that one row in your final report seems to be incorrecet. You have Top Traders with 40 sales but have a percentage of 15% rather than 20%. I also had real trouble with that particular record of the dataset returning multiple matches (It wanted to match to all of the discount amounts. I had to add some extra cide to filter to only the first row of the records to make the data correct.). I have sent my attempt at solving this problem to your email.

[@AAAExcel]

Hi Roy, thank you for your participation. I will look at your input and revert. I agree that the line you've mentioned is a bit mysterious, I will tackle this issue in the solution video, and will see how we can easily decide on which percentage to use based on the situation, I will present a solution using the UI as well as M-functions stay tuned

[@danishnawaz3651]

azamg sir.

[@AAAExcel]

Thank you 🙏

[@QuadriAtharu]

I have sent my solution to the mail

[@AAAExcel]

Thank you, will check and revert