Chandoo v/s Chandeep | Who will win? Power Query Tricks Battle 2 ⚔ |

[@GoodlyChandeep]

📌Download the Excel file - goodly.co.in/chandeep-chandoo-power-query-tricks-battle Subscribe to Chandoo's Channel - www.youtube.com/@chandoo_ If you want to learn Excel in Telugu subscribe to his Telugu Channel - www.youtube.com/@data_with_chandoo We have also met before and chit-chatted about life and Excel - kzbin.info/www/bejne/qmfTo6uknqt7a6Msi=ZPWxS8PTY-v8OGQP Power Query Trick Battle 1 - kzbin.info/www/bejne/eZ3Mip-ki7Bpgqcsi=bVdnkaQvmclW-6tf If you want to go beyond the Power Query UI enroll in my M language course - goodly.co.in/learn-m-powerquery/

[@IrshadKhan-nd2rg]

Can you make a easy way of doing this as I have tried to combined two dates from one dataset but I want this in m I'm deal with lot of tracker where I need to create summary based on single slicer to see received volume as well as closed volume kzbin.info/www/bejne/ppvOnpSFhLdmpqcsi=Ei-Ia2-E8e3MnAyI

[@chandoo_]

💥 WOOHOO... It doesn't matter what the tricks are. @Goodly is the winner for me for organizing such an entertaining and insightful battle. 🤜🤛

[@GoodlyChandeep]

THANK YOU CHANDOO. You're awesome!

[@kivk139]

@chandoo always rocks.... A pure golden heart

[@YuGao-bi8bg]

TWO of my favoriate person who lead me to DA world!!! Love you both and appreciate you both!!!

[@ziggle314]

I love when two pros get together and discuss tools. You guys are the best. Thanks for all you do!

[@mikizhero]

Chandeep is too complex, Chandoo is so simple to understand even in Excel. He is so good

[@BorisDK1]

Two of my favorites. Invite also Leyla G. - she is my third favorite teacher. You are the three I am learning PQ from. Be blessed and continue be awesome!

[@GoodlyChandeep]

Let me try to get her on the Channel.

[@hemalshahorigamilove]

Yes.. Eager to see my two favourites together 😊

[@sonyjacobtc]

@@GoodlyChandeep i was about tell what @BorisDK1 is suggesting. Waiting

[@sscpreparationmadeeasy]

Yes @leilagharani .

[@loneranger7535]

WOW- Chandoo is the OG in excel but well you're the master in PQ. Gotta say I would go with you on this one

[@rajanpradeepankarath8846]

I am following these two and learning for years now. Obviously both have their strong areas, and it is a treat when they come together. Well done guys

[@dineshwagle9832]

You both are my favorites. Very nice to see both of you together and making me feel awesome💌💌💌

[@estephanina]

This is the nerdy collab I never knew was possible!!! Awesome collection of tricks 😊

[@txreal2]

Chandeep is such a nice guy, encouraging Chandoo while he's explaining. That's a bonus point for Chandeep :)

[@emilmubarakshin49]

Excellent tricks , new and old ones :) I always appreciate it!

[@YuGao-bi8bg]

TWO of my favoriate person who lead me to DA world!!! Love you both and appreciate you both!!!

[@GosCee]

Awesome tips, Chandoo and Chandeep! Well done! I saved this to the top of my playlist.

[@ericrobbins6953]

Go Chan....duo!

[@ngenoleonard7898]

Waoouh this is the supper battle of my favorite excel tutors. Am happy to learn from you guys.

[@patrickharilantoraherinjat2994]

Thank you Chandoo and Chandeep for sharing. Chandoo's tricks are cool and more suitable for people who are beginners in Power Query, while Chandeep's content is more for advanced users. Can you gyus make a video about List.Buffer/Table.Buffer/Binary.Buffer

[@Nalaka-Wanniarachchi]

Don't care who is the best.But both of you are best of the best.

[@NaveenKumarAnnamaraju]

3:08 Rajinikanth is the answer i have expected as soon as i saw his portrait in the background

[@RakshitDwivedi-pq8qc]

Excel GOAT vs PQ GOAT. This is awesome!

[@VideoAndrega]

I would say “and” instead of “vs”. Thie is a win-win for all of us. Thank you for sharing your immense knowledge in these topics.

[@karolinab9749]

Great challenge and tips - my favourite is to comment the function and peek at the function documentation library!😊

[@PowerMacro]

Awesome Chandeep, I am thankfull both the master. Who keeps training free of cost and making us experts ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤

[@davebickers7209]

Thank you both; two of my favorite content creators. Once again I was amazed and am aware of how much I don't know.

[@ruzzputin]

Both are superstars! Love you both!

[@laurentmarc1928]

You both are the winners: each trick has its value in their context... I was delighted of your comment Chandoo on the "sloppy" effect of M Intellisense ! Power BI suite is great, and in a few places we see kind of bugs or missing possibilities that solving would be wonderful to improve the user experience without forcing to use workarounds 🙂

[@krzysztoftom]

Great Battle. I'd love to see your next battle with the guy from the channel @BA Sensei

[@edsta714]

Godzilla vs Kong Kong…Let them fight!

[@aniljaggarwal60]

बहुत बढ़िया आपके योगदान को सदैव याद रखा जाएगा जबतक जानकारियां इंटरनेट पर उपलब्ध रहेगी । जैसे हम एक्सेल में स्वयं के आईडिया से कैलकुलेशन, डाटा शेप और रिजल्ट प्राप्त करते हैं । पावर क्वेरी में आइडिया लाना मुश्किल सा लग रहा हैं । शायद मैं गलत भी हो सकता हूं इसपर मेरी प्रैक्टिस या जानकारी अधूरी हो ।

[@pabeader1941]

The answer to the tagline question is.... Us the viewers! That's who wins.

[@NhiNgo-up8js]

I love your stuff in Power query. Hope you make more video about them. I see you recently have less video about PQ than before Anyway I also really love idea about PQ battle. Learn a lot from you guys

[@srikrishnasbhat9668]

Chandoo's tricks were closer to being tricks.... Chandeep's on the other hand was more elaborate methods On the other hand, in earlier one Chandeep's was closer to being tricks and Mark's tricks were elaborate methods. Nice how Chandeep picked up and upped his presentation after the first challenge

[@frachiar4444]

Chandeep, in your first trick why do you prefer TransformRows instead of ReplaceValue? ReplaceValue to me is easier, and shorter. Maybe TransformRows is faster?

[@xlisgr8]

Nice discussion guys. All part of learning!

[@regme4life191]

Sir Chandeep@ Please have challenge with Inda Tracy next time. Thank you

[@stubb_orn_]

How do I create dynamic user roles in Power BI? Just small Brief. Roles are present in table, & according to that role user must be able to see data. Admin, Manager, Employee are 3 roles. Admin sees all project, Manager sees all project data in which he is present. User sees all project in which he is present but with access to small row in which he is actually involved.

[@keagankemp6275]

It’s a tie for me lol both these guys are legendary made me a legend in my field thanks gents

[@dirkstaszak4838]

Tip 1 Chandeep 1 point Tip 2 1 point each

[@Gavsenberg]

This was fun. The Chanduo 🔥💯

[@mustafaezzi7262]

obviously we are the winner🌟

[@ma3ab2]

I can't believe my eyes, the two superheroes together in one vedio

[@vishalborase5506]

this only goes to prove that the smartest person in the room can never be a good teacher or a trainer because they are simply there to prove that fact that they are the smartest and forget that they are there to get to the same level as their student...and thats why many find chandoo is absolutely good at..

[@EjazKhan-f3w]

❤❤❤❤❤ to both of my Teachers

[@Dev_Bartwal]

Both are rock man ❤❤❤❤❤❤❤❤❤

[@distinctcount]

Such a sweet battle ❤

[@oscararmandocisnerosruvalc8503]

I see a lot of potential to use column names and maybe skipping columns not to hard code at the end , in the first trick

[@kkravch]

Wouldn't be the trick 1 for Chandeep be easier in one step? = Table.ReplaceValue(Source, each [Sales Value], each if [Tax] >0.03 then [Sales Value] * (1 + [Tax]) else [Sales Value], Replacer.ReplaceValue,{"Sales Value"})

[@thierryprigent2225]

i think Goodly is the winner but Goodly trick's is more complexe than chandoo's tricks. For a newbee the winner is Chandoo

[@aman_mashetty5185]

Two lions roaring together -- this is legendary....!🦁🦁

[@dieudonnepare5666]

Wonderful !!!!!!!!!!!!!!!!!!!!!!!!!!!

[@deviprasadp8703]

Hlo Sir I'm a Subscriber of both of you I Like the way you people are teaching us Thank you 🙏

[@rajup4970]

It's awesome with two legends.... :) :)

[@CassidyHood]

I use the transpose column and unpivot right now!

[@syedtahirbukhari8377]

I watch all your past 4 videos

[@MaureenPesch]

Great tips from both of you!!! A question for Chandra. Would list.contains perform better than conditional columns? I have a long conditional column that groups if the column contains various vendor names, which are often spelled differently. It is a bit slow. Thank you!

[@syedtahirbukhari8377]

I haven't seen your power pivot model from basic to advanced and make also accounting

[@thamilanban]

Both my favourite gurus

[@ivanzhelyazkov6625]

You're on another level, Chandeep.

[@user-dz5xy4lp5d]

Great Session, really good

[@cesarmezaroli4069]

Very nice collab. This is as big as travis scott x Jordan.

[@WaqasKhan-sp3sn]

Chandoo u r great in trick 3

[@TRZMac]

Hey Chandeep, thanks for this great video! I wanted to ask about the PowerQuery course you made, does it focus more on Excel Use-Cases or PowerBI Use-Cases ?

[@GoodlyChandeep]

My M course is focussed on advanced data cleaning. you can use that in Excel or PBI.

[@dailyuploads3959]

thanks

[@raghavendrabatchu3933]

Superb concept

[@WaqasKhan-sp3sn]

Goodly in 1st trick

[@thanhphongle7325]

how can i change from format .gsheet => . xlsx in Power query editor, please!

[@timestoryx]

Awesome guys 🎉🎉🎉 super Chan !!! 😅

[@christopherskyap8985]

chandeep for trick 3

[@chrism9037]

Epic matchup!

[@WaqasKhan-sp3sn]

chandeep trick 6

[@dekta4]

there is no day ill bet on any dude not named Chandeep. He just the apex predator in BI realm period.

[@Faisal63045]

Thank you all

[@MrLuuHai]

I love you both👍👍👍

[@WaqasKhan-sp3sn]

Chandoo in 2nd trick

[@martyc5674]

Super -really liked the dynamic table.skip

[@rhythmkaushik7863]

who don't know chandoo... Chandoo is champion🎉

[@toirshad]

❤

[@akshayshreeshylahs5748]

Chandoo 1

[@syedtahirbukhari8377]

One thing i must say this is going outdated in future Ai will take its place start teaching now Ai allied tools if you're familiar with and in that way you also learn more from youtubes

[@ousmanesidibe951]

Chan vs Chan 😂

[@hemant5757]

Chandeep bhai tusi vi ek channel punjabi vich chalao!

[@manideepak6820]

I think chandeep doing acting Like he don't that tricks But actually he explained those long ago

[@yashuteja]

Chandoo Anna is best

[@adepukrishna]

Chandoo Anna super

[@NestorCirhuza]

@GoodlyChandeep vs @bigorilla will be great. Please

[@GoodlyChandeep]

Planning it soon :)

[@oscararmandocisnerosruvalc8503]

Make it happen !!!!

[@WaqasKhan-sp3sn]

chandeep for trick 5