วีดีโอ

Thats a wonderful solution. What if the data type is in .xml?

Didn't know that existed, very useful

I didn't know that Date.From (and it's companions) slowed the query down so much, good to know this! Could be a good video idea: things slowing down power query (especially for larger datasets)

Just awesome

Exellent video, thank you. I have question. I followed your steps but In my filter table some rows in the datecolumn get 00-01-1900 because in original table they was empty. Do you know how I can handle that so I get the data as it is in original table? I tried to include COALESCE in my filter formula but it didn't help?

You can create a Quick Part of the formatted body text (including the attachments) as a reply shortcut.

Can you write a macro to make the email like in excel … skipping the template..?

How do you assign macro in Run icon?

Another fantastic tutorial ! I am checking for new tutorials. They are that good. Even though I have worked in the office suite for the last 30+ years - there is always something new to learn. Thank you BCTI - please keep the videos coming and keep up the good work - it is really appreciated.

Great tips

thank you very much

Wow, that was a gem

I hated these helper files from the beginning. So far I tried to avoid them by creating a function like let GetFiles=(Path,Name) => let Source = Excel.Workbook(File.Contents( Path & Name ), null, true), Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data], #"Promoted Headers" = …, #xxx = … in #"xxx" in GetFiles and applied this function to the files in a folder. Your solution seems smarter as it even avoids having the function code. Brilliant. I will certainly give it try. Thanks for sharing your knowledge.

Ive been wanting to get around these helper queries for ages. Your guide is incredibly straight forward, and i cant wait to apply this new methodology in my future queries!

Great view and excellent training! What do you do when your data is not in table form? I am using a date created column from the file selection to separate the data that is on Sheet1 of the individual files. When I click to expand the Data column containing the tables, I get "Column 1", "Column 2", etc. When I promote headers, I lose the first date of the date created because it is then promoted to a header as well. How do you correct for this?

Totally agree @RichardJones73. Such excellent explaining is rare. I have learned soooo much from BCTI and I really hope that the videos keeps coming :) It is a total mystery why they don´t have x millions subscribers.

Excellent as always, clearly explained and easy to understand ❤👍🌹

I’ve just learned something new and very interesting.😀 I’m away to think of how I can use this.😀

I like your presentation style, very simple but covers everything

Yes Sir. We are following her and many others. They are all very helpful. I have learnt so much from all of them.

One question if I want to filter more than one region at once

Mr. Excel has a wonderful tutorial: th-cam.com/video/fbHQgDM0P1E/w-d-xo.htmlsi=gQMyyxio_JB74KTk

Very nice error trapping techniques! This 2nd part came with a bang! Thanks again for such great content. I also use the Powerquery formatter for the code. The code in powerquery its very daunting at the beginning of your Mcode journey. Another thing that i do is that I rename all my steps without any spaces in order to avoid the "# " prefix which is also "scary " and this keeps a good hygiene in your code

Ok. If you want zeros to appear on the canvas visual you type your measure and add a 0. Something like SUM(RevenueCheck[Check Amount])+0 . Thats how i use it to display zeros in my reports. Furthermore, I apply conditional formatting like in excel . I usually use this simple custom formatting in powerbi #,##0.00;(#,##0.00);- . I usually like to display - so its easy to browse on the report

If you enter AAbb2222 that's approved! ¿Where is the symbol here? Thank you.

What a great explanation and elegant at the same time without much Mcode. Thanks for the idea. I have a handful of queries pulling from SQL that I wanted to create parameters to bring the required data. Thanks for such a great posting. You are the best source in YT for Powerquery.

Um, what? Leila has over 2.6 million followers.

I have Excel 2021 but MS 365 is better with too many superior functions. You are so kind for suggesting following Leila. Actually, Ive been following her since 3 or more years ago. Your channel was the real catch for me. Thank you both.

I’ve seen a couple of other videos on this new REGEX function and it sure does look interesting. I will just have to wait until it goes mainstream though before getting to play with it. I used your previous video on password complexity to build one of my own. I actually built a password generator which includes the complexity test. this new way certainly looks easier.😀

I caught your joke ;)

Are these only available on insider? co pilot says they are available in all versions of xl, and if so when will we get them, still waiting for group by.

insightful vid, Thank you for your time

Zero or null can be used instead of GroupKind.Global

Agree with the comments, you really have some great focussed content - keep up the good work!

Super helpful! Is there a way to hide the original data table so the sheet would only show your query parameters and the resulting data?

Useful techniques & clear explanation. Thank you very much!

I just came across your channel. Very useful and well explained tutorials. Thanks

Thank you for such a detailed explanation, I didn't know the GroupKind parameter... very useful!

Superb Video

🙏 very helpful. I'll use this to analyse frequency data for retail stores. Thanks for your great explanations. As always a pleasure.

Great.... Thanks a lot......

Very cool! I've been looking for this kind of option with grouping.

It's so funny-every time you release a new PowerQuery video, it feels like Christmas! Keep up the amazing work

This is awesome and explained well. Thank you!

Thanks for clear explanation.

ماشاء الله تبارك الله شرح جميل جدا جدا ( الله يهديك أستاذي العزيز ويشرح صدرك لمعرفة الحقيقة )

You wanted to know how cool this video was, I would say the heat is on. One of the best explanation I have seen on this feature of GroupBy.

Tanks for the great video I such a useful feature. Trying to do it without groupkind would've been so cumbersome. BTW, what cam groupkind.type be used for?

Coming from a Python/Pandas etc. background, trying to learn the Power Query/Power BI world for work. Have watched many TH-cam videos and yours are consistently among the best: very well explained, good real-world-ish examples. Keep up the good work! Small issue with the accompanying files for this video, the Original Data ("Data") table in the Casing Test workbook doesn't have any alternate casings. Minor oversight.

Superb! Your voice quality is the best