APQ11 | Merge Queries - Next Level | Merge | M-Code | Custom Column | Records | Advanced Power Query

[@DhruvDua88]

So glad I found your channel - been struggling with this issue for a while and this is beautiful solution

[@rajanpradeepankarath8846]

This is absolutely EPIC. Records has taken the merge to a new level! Please make a video where the price is retreived correctly after the date of change. Meaning, look at my transaction date and fetch the price on or after that date from the price list

[@juja2819]

I would like to see that too. Please make such a video! :)

[@rajanpradeepankarath8846]

@@juja2819 I took up that challenge and made that one myself !

[@aaaexcelenglish]

Happy that you found it useful, if I am not mistaken, this video will answer your question
APQ12 | Exact & Approximate Match | Lookup changing Prices & Discount | Advanced Power Query
th-cam.com/video/rQZBORgxg14/w-d-xo.html

[@zahoorsarbandi2982]

Believe me! because of your teaching style and wonderful explanation Power Query has become so interesting, easy and simple. Thank you very much.

[@aaaexcelenglish]

Thank you so much Zahoor, appreciate your encouragement and support

[@jazzista1967]

HI Amir. Nice to see you back with a new video. Very helpful!

[@aaaexcelenglish]

Thank you, happy that you liked it

[@jazzista1967]

Amir.. your are a great source for PQ solutions...Please keep the videos coming

[@josh_excel]

Good job, who needs Add Custom Column when you can just make a record and expand it! Well done.

[@aaaexcelenglish]

Thank you 🙏

[@boissierepascal5755]

Absolutly brillant ! Thanks you for this wonderful demo.🙏🏽

[@aaaexcelenglish]

Thank you so much, happy that you found it useful

[@HasnainSabir-y1i]

Excellent communication and good examples

[@aaaexcelenglish]

Happy that you found it useful

[@mimiklimberg1257]

Next level!

[@aaaexcelenglish]

This is what I thought!

[@aliasghar09]

Fantastic😊..This is great...

[@aaaexcelenglish]

Thank you 🙏

[@ilkercalsr8130]

This is really inspiring as always. Thanks a lot.

[@aaaexcelenglish]

My pleasure, thank you for your comment

[@hichamhadj9640]

Genius, much love from 🇩🇿

[@aaaexcelenglish]

Thank you Hicham, Cairo loves you as well

[@juja2819]

This helped a lot! Thank you! :)

[@aaaexcelenglish]

Happy to hear that, most welcome

[@Ypurenete]

Excellent!! I have an issue like this and now o know how to solve. Thanks a lot.

[@aaaexcelenglish]

Most welcome , happy that you found it helpful 👍

[@JayantShettigar-pt6uo]

Your all the videos are very informative and amazing.

[@aaaexcelenglish]

Thank you so much

[@Bhavik_Khatri]

Excellent tutorial. Thank you very much.

[@aaaexcelenglish]

Most welcome 🙏

[@subbu_ca]

Just fantastic tutorial

[@aaaexcelenglish]

Thank you 🙏

[@brianxyz]

Very impressive!

[@aaaexcelenglish]

Thank you 🙏

[@kennethstephani692]

Great video!

[@aaaexcelenglish]

Thank you 🙏

[@UlyssesHaq]

Magical, I love it!

[@aaaexcelenglish]

Thank you 🙏

[@datawizibility]

Thank you for the wonderful tips...god bless...

[@aaaexcelenglish]

Most welcome dear

[@gezin_longuevilleosaer4245]

Very nice, thanks for sharing.

[@aaaexcelenglish]

Thanks for watching!

[@EciekPeciek]

very nice expansion to the columns.

[@aaaexcelenglish]

Thank you 🙏

[@malchicken]

Thank you for showing the trick of using each with records to extract multiple values 🙏. At 18:03, Table.Sorts comparison requirement as a list is surprising given it says “as any”; it would be much appreciated if a video was made going over how to know when a function parameter requires a list or record, even when it doesn’t say. Or maybe it just needs to be memorized? Thank you.

[@kishorpanara4191]

Excellent dear

[@aaaexcelenglish]

Thank you 🙏

[@BestICan]

Excellent!

[@aaaexcelenglish]

Thank you 🙏

[@jerrydellasala7643]

Very cool technique. It would be nice to see this done to get the one "correct" price. That is the price on the date of the sale - that is the sale date is less than the max date.

[@aaaexcelenglish]

thank you Jerry, i made video APQ12 to show exactly how you get exact price
th-cam.com/video/rQZBORgxg14/w-d-xo.html

[@pabeader1941]

Here is a challenge for you. Get the price that was in effect when the product was purchased. So you could have a different price for each item, even if they are the same item.

[@aaaexcelenglish]

This one is much easier, in such a case I would use table.selectrows to filter down the price list for all price before the purchase date, then I would pick the last item using list.last(provided that the price list is sorted properly)

[@pabeader1941]

@@aaaexcelenglish Oh that is wonderful!!! You are for sure someone that I am going to follow and sub to.

[@DeepakKumar-hs1tq]

I have a question for you. I am merging the query . After merger done i can see the duplicate entry updated by power query.How to avoid this step and i cannot delete the duplicate entry there are duplicate amounts in another tab

[@aaaexcelenglish]

Try inner join kind if it suits your requirements

[@SaleemShouket-r3p]

Great

[@aaaexcelenglish]

Thank you 🙏

[@stephenbui490]

I've been here and let you know. I'm still confused about how and when to use table, list and record in power query

[@antoniofelez4674]

What if I have a scenarios where I need to bring over a city name instead of price. And the SalesData table has extra products not present in PriceList table. And also on the PriceList table different products can have same city name. So in the end I want to bring over city name to SalesData table, and also get rid of the extra products in SalesData.

[@aaaexcelenglish]

Try to change the join kind to inner or right outer, if I understood correctly

[@jawadahmadehssan6251]

Beautifully done. Thank you

[@aaaexcelenglish]

Thank you too!