Merge Queries in Power Query (WHY - Handle Speed & Volume)

You may not be aware that Merge Queries are the most effective alternative to Vlookup & Index. You will learn how to use merge queries in Power Query and Power BI.
🔗 Download Practice file - bit.ly/3ujiXll
👉 Check out our 22 hrs. Full Excel Course in Hindi - bit.ly/2SEEPsk
We covered the following topics:
00:00 Introduction to Power Query
01:00 How do you do basic & advanced Lookup in Power Query
02:07 What's Merge Queries in Power Query
02:48 What is Append Queries in Power Query
03:32 Case Study: Merge Queries - Part 1
05:18 How to open Power Query in Excel
05:35 How to use Transform Data Function in Power Query
05:44 How to Import Excel File into Power Query
06:49 How to use Merge Queries Function in Power Query
09:42 Power Query is Case Sensitive - Solution
11:13 How to use TRIM Function in Power Query
11:56 How to use Fuzzy matching to perform the merge in Power Query
13:16 Need for Unpivot Column. Concatenated Lookup
17:16 How to Unpivot Column in Power Query
20:03 Duplicate Primary keys (Cartesian Product)
26:07 Detailed Case Study on JOIN Types
34:37 How to use Merge query as new Function in Power Query
✔️ Fuzzy Matching for Multiple Excel Tables - • Fuzzy Matching for Mul...
✔️ Excel Power Query 5 Case Studies Under 60 Minutes - • Excel Power Query - 5 ...
Merge Queries in Power Query (WHY - Handle Speed & Volume)
#powerquery #mergequeries #powerqueryinhindi
To watch more videos visit: www.excelsuperstar.org/​​​​​​​​​
To Buy an Excel Course visit: www.courses.excelsuperstar.org
Like us on Facebook: / excelsuperstar​​
Subscribe to the Channel: / excelsuperstar

[@SanviPatil2019]

मैं ऋषभ सर के video २०१४ से देख रहा हुं.. ओर उन्हे देखं कर आज बहोत अच्छा excel सिख चुका हुं , आगे भी ऋषभ सर से सिखुंगा..

[@surbhirautaray6872]

Superb explanation.

[@shaibazbanu9444]

very helpful video,thank you

[@DevendraBhusal-ku3yo]

Nice explanatory.

[@user-lu8bi9sf9y]

Very informative video

[@pankajjain5916]

Thanks Rishabh for providing us so much knowledge. Your sessions help us to do our work very fast

[@MDYOUSUF-tl8sk]

This video deserved more than 10,000 likes

[@VipulJain40]

Guruji.. Zabardast Video.. 👌

[@kishanmatanhelia1221]

One of the best explanation about Merge Query

[@dr.sushilkumarph.d.8186]

Excellent Video.........very informative.......Thanks Excel Superstar

[@aakashjoshi6239]

Thank you Rishabh Sir....Your Tutorial on Power Query helps me to understand in easy way and I do my work in a faster and smarter way.....I saw power query video of other youtube guru's but your style of teaching is excellent sir.....Thank you very much sir.👍

[@ravi2191990]

Thankyou Rishabh ji, I joined the page a day ago. Very informative videos. I’m learning.

[@canirmalchoudhary8173]

Very nice I know Power Query but in depth join type and concatenated lookup are new learning for me. Thank you 😊

[@atiqurrahman8010]

Well done Sir..Keep your good work get going

[@manojmishra-lq4nh]

The way you explain concepts are really awesome 🙂

[@entertainmentgolife6632]

Awesome Video !! keep it up ..

[@shivkeshkanoujiya2183]

Thank You Sir for the Video

[@sunilkumar-jl7uf]

Excellent presentation

[@SanviPatil2019]

Superb...

[@aalerazi9975]

Excellent

[@DineshSardesai]

Great video

[@arnavaj3392]

Your voice 👌

[@dipakdash9867]

Excelent

[@sonukumar-xp5sd]

Awesome

[@KamranMumtazAhmed]

Hello, when I started to watch your videos I didn't like you because you didn't share practice files and you stretch the videos unnecessarily but after watching today's video I became your fan, the way you have elaborated every part of the merged query is undoubtedly amazing. You are doing great and sooner you will be recognized by Microsoft. Videos on excel, power BI and PQ for Hindi/Urdu learners in this much details are rear. Hoping to see you sharing your becoming Microsoft MVP moment soon. Love and respect from 🇵🇰

[@rishabhpugalia9281]

Thanks. The feedback helped me improve. Will keep working on more improvement

[@ranaganguli2892]

Basic is excel, and next is pro... Really wow...

[@muhammadazlan8979]

Thanks Rishabh for sharing my name in your video you are such amazing

[@sujoymondal6977]

I love you brother .i like very much your video i dont miss your video

[@RohitSingh-ml9zb]

Please more videos about depth's topic about power query with more practical examples.

[@chandramohan1418]

PL videos on DAX functions in powerpiovt.thank Yu.

[@manananand17]

Hi, Could you please make a video on consolidating multiple business units data nd showing using power query & slicers.

[@hemantkumarannaldas4946]

Hi Rishabh, I want to use conditional formula in excel, for eg. if the value is 20 or more then the answer in cell should be 20 and if it is less than 20 (say 14.73 then I need the value 14.73 in the cell(not the cell address)) when I am using the formula =IF(L14>20,20,"=L14") the answers which shows in cell is =L14. please do help me with formula and logic used here.

[@faisal9007]

Please... guide me how remove null rows in power query data

[@hiteshchourey9730]

Sir, data enalysis kya hai. How to use video please banaye

[@dipakpatil3511]

वीडियो कितना भी लंबा हो मगर excel का ज्ञान बढाने वाला है, और हा सर मेरा लडका कहता है कि, आपकी आवाज बहुत ही मधुर लगती है , धन्यवाद! सर

[@rishabhpugalia9281]

Bahut khoob. Good to hear your son is also learning! My blessings to him

[@Sahil.Khanna]

Hello sir.. i just want to ask you some thing that.. how to do a command in excel i.e if one amount is more than 250000 than split amount into two or three amount but total remains same and qty also rounded off

[@Zarbetauheed]

Sir, Oracle based form banane k liye kon sa course krna padega

[@technoarunav]

Rishabh -> Aapki Hindi itni shudh hai ke mujhe mere school ke time ke Hindi teacher yaad aagaye aur sath mein computer teacher bhi....LoL😆 Otherwise hatsoff to your style of teaching!! Very Nice!

[@ExcelSuperstar]

Thanks

[@badshahbhai1333]

Very well sir your portal is very effective in my working but my humble request please making a video in VBA coding. Because to much video available in KZbin but isn't understand sir I understand only your video😏 Thanks sir

[@rishabhpugalia9281]

Sunkar achcha lagaa

[@badshahbhai1333]

Phr Kuch sochen Meri request k opr sir

[@pujakayastha2971]

Sir 365 mai kaha hai