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

[@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