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

Подписаться 89 тыс.

Просмотров 22 тыс.

50% 1

Join us for an epic Power Query tricks battle between Me and Mark Proctor! In this video, Mark and I will each share seven powerful tricks to up your Excel game.
As we showcase our expertise, you get to decide who wins each round by scoring our tricks. Who will win this battle? Watch till the end to vote and see who comes out on top!
Don't forget to subscribe to Mark's channel - @ExcelOffTheGrid
• Promote Double Headers...
===== ONLINE COURSES =====
✔️ Master 'M' in Power Query -
goodly.co.in/learn-m-powerquery/
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course -
goodly.co.in/learn-power-query/
===== LINKS 🔗 =====
Blog 📰 - www.goodly.co.in/blog/
Corporate Training 👨‍🏫 - www.goodly.co.in/training/
Need my help on a Project 💻- www.goodly.co.in/consulting/
Download File ⬇️ - goodly.co.in/Chandeep-vs-Mark...
===== CHAPTERS =====
00:00 Intro
04:18 Mark 1
08:24 Chandeep 1
10:54 Mark 2
14:50 Chandeep 2
18:10 Mark 3
21:16 Chandeep 3
26:10 Mark 4
29:28 Chandeep 4
31:02 Mark 5
32:56 Chandeep 5
35:43 Mark 6
39:32 Chandeep 6
41:21 Mark 7
47:36 Chandeep 7
===== CONTACT 🌐 =====
Twitter - / chandeep2786
LinkedIn - / chandeepchhabra
Email - goodly.wordpress@gmail.com
===== WHO AM I? =====
A lot of people think that my name is Goodly, it's NOT ;)
My name is Chandeep. Goodly is my full-time venture where I share what I learn about Excel and Power BI.
Please browse around, you'll find a ton of interesting videos that I have created :) Cheers!

Наука

Опубликовано:

26 июн 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 175

@GoodlyChandeep Месяц назад

Don't forget to give us points in the comments and let's see who wins! 😉 Mark's channel - www.youtube.com/@ExcelOffTheGrid Promote Double Headers in Power Query | Solution - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-fql8M8qdVRw.html Download the file ⬇ - goodly.co.in/Chandeep-vs-Mark-Power-Query-Tricks-Battle Master M in Power Query - goodly.co.in/learn-m-powerquery/ Don't forget to hit the like button if you enjoyed the challenge, and subscribe for more awesome content!

@thicketroad Месяц назад

I think we're all winners with this vid.

@jean-claudebrunet1645 Месяц назад

Guys, you are genius . You are equally brilliant. This is a draw but the real winner is me a I am the beneficiary of your tricks 😃

@nizararena Месяц назад

Timestamps to help : trick 1: 4:19 trick 2: 8:25 trick 3: 10:55 trick 4: 14:51 trick 5: 18:10 trick 6: 21:17 trick 7: 26:10 trick 8: 29:26 trick 9: 31:01 trick 10: 32:58 trick 11: 35:44 trick 12: 39:33 trick 13: 41:20 trick 14: 47:36

@ziggle314 Месяц назад

Two of my favorite Excel gurus having a friendly competition. It doesn't get any better than this. Thanks!

@GeertDelmulle Месяц назад

For me it’s Mark for the win because of the following canons he pulled out of his hat of tricks: “flatten headers”, “query in a step” and “Merge does the fastest exact match”. They made the difference for me. All the tricks are good, but those stood out for me.

@edsta714 Месяц назад

King Kong vs Godzilla. Let them fight.

@Nousername88 Месяц назад

I rarely have enough attention span to sit and watch anything longer than 20mins video. This was one of the rare ones where I was able to do that. Thanks mark and chandeep, you guys should keep the collaboration going !

@NeshaStanic Месяц назад

This is great. You should practice this often. No winners here, only us, audience.

@michaeloloishuro6915 Месяц назад

Hi Team of Champs>Mark and Chandeep. Having been following the two, I know you are both Giants and the synergy here is explosive. Great job and justice done to educating us on various employable tricks. Thanks.

@ericrobbins6953 Месяц назад

Wonderful contest between two Grand Master wizards casting their M magic. Removing Null columns is sick and I am using today. This would be such a fantastic regular series!

@williamarthur4801 Месяц назад

Really liked the add columns, I was thinking of your 'creating dynamic columns ' challenge, where I'd changed it so then names were header and 'hobbies ' row headers, done this a few ways, and think this may be a new way. find 'off the grid ' really useful long before I found mark on youtube

@kebincui Месяц назад

For Mark's tip No. 4 (Removing Null Columns), if you first change the data type to whole number, then you can apply filter to [NullCount] column without the bug error message (at 27':32'' of the video)

@wynhopkins4023 Месяц назад

Bravo! An honourable draw covering some great tricks

@BIGorilla Месяц назад

What a video the Power Query community much needed. Two giants, one battle. Both with endless moves to shoot at each other. Im glad you finally agreed to a truce. The world gets to live another day. I bet this battle could have lasted for weeks. 😉

@shirleymoreman6725 Месяц назад

Mark 7 Chandeep 7! You guys! Those were 14 absolutely awesome tricks. Thanks for putting this together.

@sivakumarilluru560 19 дней назад

Thanks Chandeep and Mark ...For my Prospective both are winners .. Once again Thank you for sharing Best tricks in power Query.

@frankschadler9407 Месяц назад

Wow. Serveral awsome tips, thank you, Chandeep and Mark. A voting is difficult. I know most of your tips, Chandeep. And as a former SAP-R3 user, I can imagine that Mark's tips are more than helpful for those who suffer from these special tables where essential information is above the table. Please allow some questions: Why did you, Mark, use merge / right outer instead of inner join? (Battle 6) What is the benefit of the code optimizations? I ask because I always have to correct code to respond to changes in the data. If you summarize everything, checking and correcting becomes difficult.

@navisalomi Месяц назад

Table.Profile from Mark, Groupkind.local from Chandeep. Awesome. Great guys 🎉

@isaacmireku5805 Месяц назад

Very Impressive @GoodlyChandeep. Bless you

@zuzanasmekalova4632 Месяц назад

Great video of two great PQ masters! From my current user level/knowledge I give 4 points for Chandeep for "add more columns in one step", "automatically promoted headers", "is number/is text"; "transform all columns" and 3 points to Mark "filtering data with right outer merge", "get the info/date from removed rows", "query in custom column" As somebody wrote before me - we are all winning here! :) thanks!

@txreal2 Месяц назад

I follow and admire both. Chandeep got the bonus +1 point just because he promotes this ideas ✨ and shares with us. Now that's Goodly stuff 👍

@bendreessen2809 Месяц назад

Awesome tricks from both Chandeep and Mark! Several tricks are immediately applicable to my queries. The most helpful include Projections, Local Grouping, Dynamic File Path, Fetching Date Columns, and Use Merge to Filter. Thank you both for the tips! As for the points Mark - 4 Chandeep - 3

@jonallen9910 Месяц назад

Thank you for sharing your abilities

@dharmmu Месяц назад

Mark tricks was more which we require in day today professional work....

@shellycastille4991 Месяц назад

More, more, more. This was an absolutely fabulous idea for a video.

@vebe7109 Месяц назад

Great tricks ! Need part 2🎉

@adityachouhan5968 Месяц назад

For me you both are the winner !!! but since 5 to 6 month i am following Chandeep and learnt lots of things , hence my softer side always goes to my guru (Chandeep).

@anillpatel Месяц назад

What a privilege to learn from two awesome 'Powerhouses'. I'm definitely a winner out of this...., Thank you Chandeep and thank you Mark....,

@omarbbah Месяц назад

This is just awesome! Just to add to Mark's first trick, instead of manually typing the date you can create a Table of dates from the files in the folder by creating a new query and maintaining the file name column. You output this as a table and create a data validation from it. This will eliminate the manual input of dates and mitigated errors.

@rajanpradeepankarath8846 Месяц назад

It is not about the points, it is rather about the value you both imparted to us. Thanks both

@McIlravyInc Месяц назад

I was searching just today for a way to clean all columns without hard coding and couldn't find anything so the the empty list brackets tip is very timely! And this was fun to watch too which actually makes it easier to remember. Bravo to you both!

@christiankramer8526 Месяц назад

You are amazing, you are both winners !!! Well done !!! 👍👍👍

@sebfromgermany3819 Месяц назад

Lovely idea to have a competion that boosts creativity. I follow both of these geniuses-each with its own admirable style👏. This competition shows once more both gentlemen know ALL the awesome tricks of the trade 🪄. Mark 7-Chandeep 7 + 1 bonus point, because you can't beat the simplicity of the trick of using records to add columns. Great of you both - Cheers guys! The audience is the ultimate winner 🎉

@sudbn Месяц назад

most awaited

@AnbarasuAnnamalai Месяц назад

Awesome tips. Thank you Chandeep for bringing Mark. You both are rocking.

@piotrm7330 Месяц назад

Personally for me ... Mark 7, Chandeep 4 (tricks 2, 5-7), and not because I don't like you Chandeep ;), but because I find Mark's tricks more usefull. Anyway, both of you are worth to follow. Good job

@chrism9037 Месяц назад

Two PQ masters!

@rachidwatcher5860 Месяц назад

Thanks to both of you. Amazing tricks!

@User-jr5xf Месяц назад

Just WOW ! I think i have several uses for this, and thanks Gents for taking the time. I'd say 7-7. I need to test what i've learned, and may have a good example, for a follow up video, if i can't understand it myself.

@husnainmanzoor8665 Месяц назад

That add query into custom column. Lovely

@justapasserby69420 Месяц назад

Unstoppable force, meet immovable object

@baskis69 Месяц назад

Brilliant, spectacular tricks, thanks for sharing. My favourite is Mark's trick #7.

@whizzohk Месяц назад

Entertaining AND educational... thank you both! You are both winners in my book. Really appreciate you sharing the actual files you were working with. Plenty of useful nuggets in there.

@PeterTurrell-cg9ji Месяц назад

Both of you presented thoughtful and worthwhile tricks. A tie well done.

@rrrraaaacccc80 Месяц назад

Great both of you 💯👍

@ericrobbins6953 Месяц назад

Watching again and again. The concatenation and appending columns in one step was very cool. Both of you bringing some great content. Mark's is awesome for solving tricky situations. Chandeep's tips I will probably use more often. Tie contest waiting for the tie-breaker.

@txreal2 Месяц назад

Yes, another video for tie-breaker :)

@pamphlex Месяц назад

This is a banger!

@prabhuji3337 Месяц назад

Mark 4 Chandeep 3 Common Chandeep! Blow him away in the next one. (Awesome tricks loading...:))

@009hjs Месяц назад

Both of you are super, thank you so much

@kaushikbarot9653 Месяц назад

Getting a single column as a table was new to me. It's great !!

@austinbushnell7448 Месяц назад

That was awesome 👍

@efficiency365 Месяц назад

Great stuff.

@Rice0987 Месяц назад

Nice to meet you guys all together!🤗 You both are super boss!✊😁

@alexrosen8762 Месяц назад

Finally!

@Maartenmarsje Месяц назад

Brilliant video! Thanks you so much! I’ve learned a lot of new tricks due to your competition.

@ianaugusto888 9 дней назад

Vocês são INCRIVEIS!!! 7 x 7 😍😍😍😍😍😍

@JUHILLAPSIWALA007 20 дней назад

You both are my idol as both sides of the coin. ❤

@bhagipatel5180 Месяц назад

Great Learning, you both are winners

@arokiarajan1230 Месяц назад

Flattenheaderrows - Mark Great-tips. Thanks mate.

@azeezwahab5188 28 дней назад

Two great mentors.

@NhiNgo-up8js 6 дней назад

thank you, all are awesome

@jaybuddhadev3543 14 дней назад

both were great . got to learn many new tricks

@GlenCoulthard Месяц назад

Amazing tips -- one of the most useful videos I've watched in a long time!

@rajkumarrajan8059 6 дней назад

Chandeep is amazing!! Chandeep winner Chandeep 7 Mark 6

@vsrinivasan574 Месяц назад

Very Very Useful tips, both have made us win, excellent, Thanks,. Removing blank columns made my life easy

@SeelanRobert Месяц назад

You guys are Awesome Amazing PQ Tricks at the end everyone is benefited. Thank you so much

@sravankumar4860 Месяц назад

Damn I feel the video is literally short..keep doing this man. many thanks to you ❤❤

@salahaldeen7924 Месяц назад

7 for each .... Chandeep one more star for you .. from Muscat

@nicolasyans7986 Месяц назад

Same here you guys are both giants. Each with its own specificities and coding style. Discovered the table.profile function that will come handy at times (thumbs up for Mark). Everlasting thanks to Chandeep for his video on Table.transformcolumns tutorial. I didn’t’ know Mark at the start of my PowerQry journey, so my vote goes to Chandeep who has taught me so much. But keep it up hoth if you your work is so inspiring.

@SndfOmar Месяц назад

Wow! The GOATs of PQ showing their magic in front of our mesmerized eyes! This is a compact video, total of 14 into one AWESOME video. You guys were both great and sport. Chandeep deliberately threw a weak first hand, as he's the host.😉 😄 Mark 7, Chandeep 6. 😅

@lakshmankumar-sq7nr Месяц назад

I am the winner with you guys tricks

@valerylambert4673 Месяц назад

Excellent! I give all the points to each of you. For my point of view, you are ex aequo! It is an excellent idea. Feel free to do another challenge of this type whenever you want!

@denisprodhomme Месяц назад

This was awesome !!! Mark : 100 ! Chandeep : 100 !

@RonnySadamHusen Месяц назад

Both are the best. I give the highest point for both of them.

@Acerdaparrales Месяц назад

You are awesome guys

@advrohitowhal9794 Месяц назад

Mark 7 | Chandeep 7. Wonderful job done. Thanks a lot!

@victor_wang_1 Месяц назад

Mark's trick number 6 is so important and so common to miss. No amount of custom M code will be better than simple joins.

@holahandstrom Месяц назад

Excellent tips & tricks

@Ratnakumarwrites Месяц назад

Nice Collab... I learnt lot from both of you... I like Chandeep's great way of teaching style, I learnt more from him.. Simple and elegant, superb. Mark I like his tricks great.

@umesh2403 Месяц назад

Am a happy boy too and am I did indeed have that rabbit out of hat moment in all those tricks. .guys I wish more of these short but useful titbits

@waleedalhasan85 Месяц назад

You are amazing, you are both winners !!! ⭐️⭐️⭐️⭐️⭐️⭐️ Chandeep ⭐️⭐️⭐️⭐️⭐️ Mark

@parmarrahul2680 3 дня назад

Aapka videos bahut sikhne vale hote hai fir bhi aapka like kam hote hai qki hindi me video nhi hai isiliye ❤

@zahir585 Месяц назад

While I find both of your techniques very interesting, I have to vote for Chandeep due to his highly selective tricks. Chandeep 7, while Mark scores 6 😅

@leewism Месяц назад

Great tricks! My scoring Mark 4 - Chandeep 5

@nesha278 Месяц назад

Pure Gold 🥇🥇🥇🥇

@retamapark Месяц назад

Thanks!

@DanielBula1964 Месяц назад

You are geniuses. I call it a draw. Blessings!

@PowerMacro Месяц назад

Most of the tricks you Chandeep already covered, which mark has shown. Full points to Chandeep. But, knowledge is knowledge. Wherever you get it Grab it. Thanks guys for wonderful healthy competition. Thank you thank you and millions of thank you.

@orasha4846 6 дней назад

We are all winners for having the opportunity to watch this tricks battle. P.S Mark I want the function library functions!!!!!

@rey022ph 3 дня назад

Chandeep and Mark you two are great! I continue to learn from you guys and this one is another big learning. I just have a question on the trick number 2 of Mark. I tried to apply the steps to nested tables but for whatever reason, the added column is giving me errors. Thank you.

@kndeepak Месяц назад

Spectacular!! No winners..

@XcelMaestro Месяц назад

Mark and chandeep both are champion Both are my teacher 7 for Mark and 7 for Chandeep

@leemorgan8007 Месяц назад

Amazing work to both of you - some of this blows my mind and I now need to see how I can translate this into my work. I scored Mark 6 - Chandeep 6 - a worthy draw.

@lourdesdelcampo8722 Месяц назад

will rewatch again and again, both equally winners by my count, Mark 7 Chandeep 7

@peterbebbington3435 Месяц назад

Excellent. Can you add the timings for each trick?

@giorgioberardi3940 Месяц назад

That's absolutely great value all round, guys. 7 : 7 is a fair score 🙂

@DinoDelight Месяц назад

Every trick was great, but the one I know I will use constantly from know is the change all data by {}

@muhammadtambawala6379 Месяц назад

Thanks

@DinoDelight 22 дня назад

Thsnk you for this video, I keep coming back to this video as I keep requiring things that you have covered here, for example I used mark column location trick today....was a came changer for what I was working with