I Bet You Don't Know All These Power Query Tricks

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

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

50% 1

Check out our newly launched M Language course ↗️ - goodly.co.in/learn-m-powerquery/
Here are seven mind-blowing Power Query tricks - Promoting headers without a promoted headers step, Extracting any Intermediary Step, Dynamically Expanding Tables, Projections, Sections Keyword, Is Keyword, and '&' Keyword!
Imke's Blog Link - www.thebiccountant.com/2023/0...
===== ONLINE COURSES =====
✔️ Mastering DAX in Power BI -
goodly.co.in/learn-dax-powerbi/
✔️ Power Query Course-
goodly.co.in/learn-power-query/
✔️ Master Excel Step by Step-
goodly.co.in/learn-excel/
✔️ Business Intelligence Dashboards-
goodly.co.in/learn-excel-dash...
===== 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/bet-you-dont-kno...
===== 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'd find a ton of interesting videos that I have created :) Cheers!

Наука

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

16 май 2023

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@hashi856 Год назад

The meta trick is awesome. I've been having to create a copy of the query any time I want to convert it into a list of records.

@randomguy-jo1vq Год назад

0:19 Promote Headers without step 1:28 Extract any intermediary step 4:00 Meta keyword 5:09 dynamic expansion of the tables 7:07 projections 8:18 sections keyword 9:18 is keyword 10:21 & Operator

@emilmubarakshin49 8 месяцев назад

Thank you for adding this!

@randomguy-jo1vq 8 месяцев назад

@@emilmubarakshin49 my pleasure

@sachin.tandon Год назад

Very slickly and succintly presented. I also like the video clips of the brand and other areas that make the tutorial easier to follow. Makes it look very professional!

@jeromeastier462 Год назад

Love the error! Seriously I might have known the first one, but the one that I really dig is the dynamic expand data.

@lynxwomancat Год назад

Love the promoted header trick from null to true! Thank you so much for sharing your vast PQ knowledge with us!

@GoodlyChandeep Год назад

Glad you liked this Sandy!

@jake967 Год назад

This channel is outstanding. Thanks for the efficient demos!

@GoodlyChandeep Год назад

Thank You Jake!

@thebhaskarjoshi Год назад

Wow... Amazing tricks One Suggestion: Try to add time stamp in the description of each video. It'll help user to refer back any one point quickly for revision purpose later in time.

@flyingHubby Год назад

Meta is awesome. Keep all the code, that creates multiple output objects, together in one place and refer to it from the outside. Great structure.

@zahoorsarbandi2982 Год назад

All tricks are amazing and very useful. Thanks for sharing.

@advrohitowhal9794 Год назад

Amazing....Thanks!!!!!!

@jeromeastier462 Год назад

Just used extract any steps + Dynamic Expand. Awsome!

@pianoquatrevingtquinze9220 Год назад

I've been using power query with the GUI for a few years now. Since I have been following you videos, I have made great progress. Thank you very much. Also, I want to tell you that I love your style, it's a pleasure to follow you. Thank you!

@GoodlyChandeep Год назад

Thank you so much 💖

@comsavvy_ogp 3 месяца назад

After watching this video, I have gained a better understanding of meta and is keywords. These tricks are amazing!

@girishsawant8263 11 месяцев назад

Thank you very much for sharing such valuable knowledge.

@user-tq2te6bc5d Год назад

Awesome tricks. thanks for your demo excellent

@gdecome 8 месяцев назад

Really cool tricks ... thanks for sharing

@barotkaushik Год назад

You can have multiple metadata with the following syntax meta [first = Source,second=FilteredData]

@jeromeastier462 Год назад

Excellent! Thanx!!

@teaking1981 Год назад

I would go for the QOL ones, projection, "IS", and "&" they make coding easier to read and simplify it.

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

Fell in love with the "error" advertisement to your channel. XD

@vinhwizard 9 месяцев назад

Very useful. Thank you so much

@rickychen1086 11 месяцев назад

great video as always Chandeep! Metadata one is good, did not know it before. for dynamically expanding table, is there a way to do so to expand all the csv files within a folder. using Power Query UI to do that will automatically invoke a custom function and it is a bit messy.

@gauravthosar593 Год назад

Awesome tricks, all are most wanted for me

@Rice0987 Год назад

Omaga!😲 This is just divine!👏😓 Thank you power monster!😆🤗

@kennethstephani692 Год назад

Great video!

@markusleucht6603 Год назад

WOW! Occult Knowledge from the initiated. Worth every second. Thanks so much for your hard work, Chandeep!

@GoodlyChandeep Год назад

Wow occult.. heard that beyond the textbook after a long long time. Cheers and Thanks

@AK-ij9il 8 месяцев назад

@@GoodlyChandeep my power BI project data is unstructured, unable to transform correctly by using power query, what will I do?

@BrainyBrunetteBarbie Год назад

Great video! Also, that error message was hilarious.

@MS-sb3gv Год назад

That “is” trick will be very useful. Can’t believe I haven’t used it before

@vinothe6707 Год назад

All new tricks I learned today is pretty awesome.... Thank you

@GoodlyChandeep Год назад

Thanks Vinoth!

@bulbulahmed3098 Год назад

Great❤

@danishnawaz7504 Год назад

Amazing.. But Expedite the Video series. On Multiple PQ Functions.. Like as Tables As well as List Functions....

@reanalytics1863 Год назад

You are wonderful

@ashleehuff3710 Год назад

Very clever way to get viewers to subscribe to your channel, I laughed out loud... and then subscribed.

@enocharthur4322 Год назад

Wow wow wow this is amazing

@arungupta8444 Год назад

Hi Sir, if there is a set of different Excel files and there are steps applied to them, like merge, combine and group, and there is an update in one/many Excel files in terms of values and it is not possible to update each and every column value, in this case how can we replace the Excel file/files (keeping the same file name) so that the all the steps can/will be applied as it is after file replacement

@raimundojs9547 Год назад

Simply brilliant!!! "Expression.Error: WTF: This viewer is not Subscribed to your Channel" > now that would be a critical and unforgiven error!

@ibrahim82649 3 месяца назад

Awesome

@GeertDelmulle Год назад

Unknown to me were: meta, is and the fact that that other thing is called “projection” (I just thought is was a way to extract one or more columns as a table, which it is). Several of these tricks you’ve shown before. As new trick I like that “is” trick.

@emilmubarakshin49 8 месяцев назад

knew a few first tricks - from your previous videos but not the last ones...

@dannyshort2305 Год назад

5:57 😂 brilliant

@GoodlyChandeep Год назад

I created a custom subscribe error. 😁😁

@TheWeteyezz 10 месяцев назад

Can you make a video explaining table/list .buffer... how and when to use them?

@martyc5674 Год назад

Brilliant stuff as always Chandeep- Voted BTW 👍

@zahir585 Год назад

Bad ass 💪🏻🙌🏻🙌🏻🙌🏻🙌🏻

@GoodlyChandeep Год назад

Yo! Thanks🙌

@kaushikbarot9653 Год назад

Can we use meta multiple times or use meta in list or record which can provide output of different steps?

@sandipansarkar9211 6 месяцев назад

Finished watching

@mohamedfouad7958 Год назад

Thank you for these new tricks of coding in queries

@GoodlyChandeep Год назад

Glad you liked them Mohamed!

@mahathmasadineni2884 Год назад

Hi chandeep as usual awesome. If possible could please do a vedio on how to fix PQ errors when the data structure is changed. Like missing of columns or columns name changes. Because of hardcoding of column of column names we get the errors. How to fix this issue. - please help?Thanks

@Anthony_Lecoq Год назад

Meta was new for me. Impatient to test it and to see if it keeps query folding ;)

@GoodlyChandeep Год назад

Please drop in a comment. Let me know what you find :)

@rhaps2008 Год назад

all new tricks thank you so much

@GoodlyChandeep Год назад

Glad it was helpful Lucena!

@user-kk8ne7pg5d Год назад

The Meta trick is great, I was looking for that.

@GoodlyChandeep Год назад

Glad it was helpful Stephan!

@KirillBezzubkine Год назад

5:56 - maaaaan that was the best PQ trick evaaaaa

@jerrydellasala7643 Год назад

Wow, one of THE best PQ Tricks video I've seen! Hey, I downloaded your file and had to correct the data source in the Tricks Workbook. However, under Data -> Get Data -> Data Source Settings, the source was set to your folder, and the [Change Source] button was disabled. I've run into this often. Is there a way to fix that? Thanks for a REALLY GREAT video!

@GoodlyChandeep Год назад

If you edit the Excel.Workbook function, it gets disabled. I think creating a parameter would be a good way of solving this.

@hemant_pal Год назад

All are awesome tricks

@GoodlyChandeep Год назад

Glad you liked them Hemant !

@KhemitPrince Год назад

Second guessed if I was subscribed, love it 😂

@GoodlyChandeep Год назад

Haha.. Cheers!

@nigilv.d4237 Год назад

Sir these all things on ur online course as well right (powerquery)

@Bhavik_Khatri Год назад

Very nice tricks

@GoodlyChandeep Год назад

Glad you liked them Bhavik!

@lovlyhearts288 Год назад

How to import an excel file from a sharepoint folder / web without Transform sample file queries? I am expecting a view and single query like when I import file from the local desktop.

@kaushikbarot9653 Год назад

Good use case of projections?

@HEMENDRAPARIDA Год назад

All the videos are awesome.. will subscribe for a paid one soon. 🎉

@GoodlyChandeep Год назад

Thanks Hemendra!

@girishsawant8263 11 месяцев назад

I'm unable to see Display Option in the Advance editor in power query...without which I'm unable to see steps numbering. How to activate this option. I have Excel 2019 version. Please help. Thank You !!

@workstuff5253 Год назад

Loved the error message!! 🤣

@GoodlyChandeep Год назад

haha! Thanks ! 😉

@baskarmani3573 Год назад

Hi Chandeep, Could you upload the excel sheet with which demo is made. It would help us lot for practicing....

@GoodlyChandeep Год назад

goodly.co.in/bet-you-dont-know-all-these-power-query-tricks/

@christopherskyap8985 Год назад

Hi Sir, how about csv files ? = Csv.Document(File.Contents("d:\Downloads\Monthly-taxi-population.csv"),[Delimiter=",", Columns=3, Encoding=1252, QuoteStyle=QuoteStyle.None]) ?

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

I knew only the first one!!!

@silverfunnel6819 Год назад

5:57 👍

@JJ_TheGreat Год назад

11:01 Do all have to be the same data type, in order to be combined?

@GoodlyChandeep Год назад

Yes, the data types must match in order to merge them.

@jamesmoran3573 Год назад

How zoom in and out works while explaining? Wt tool to use bro please some one help on this.

@GoodlyChandeep Год назад

Ctrl Shift + to zoom in Ctrl Shift - to zoom out Highlighting tool - Zoomit

@jamesmoran3573 Год назад

@@GoodlyChandeep thanks a lot.

@HachiAdachi Год назад

Didn't know #2 (metadata method), #6 (is) and #7 (&)... Proud that I actually knew 4 out of 7, but it's still 57% = F grade... 😔 Nonetheless, thank you, Chandeep!

@muzniahamed5887 Год назад

Hi sir I am from Sri Lanka I have a question about power query "HOW TO REDUCE THE LODING TIME IN POWER QUERY" please reply this sir I am facing big issue in PQ

@GoodlyChandeep Год назад

This video might be useful to you. ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-4S_aore7ezg.html