Fascinating! Many thanks. 😊

You showed a new world of Conditional Formatting . Great efforts and creativity. Thank you very much.

Great!

Thank You very much. Your teaching is an eyeopener. I Learnt a Lot.

Very useful real case scenarios, your videos are really wonderful. Appreciate your efforts. You should get Million subscribers soon. Normally I don't subscribe to any channels, but I have done it now. Thanks.

Greetings from Egypt , since the first time I saw I video for you I decided to watch whatever are your posting on YT because you are smart

I've seen this with the data model, but never knew the nuts and bolts as to why. I won't get mad at it anymore. How did you figure out that it is a memory management strategy by way of the various encodings?

This was helpful. True story - I'm so dumb, that until recently,I used to spend time in PQ sorting AND arranging columns. Did a lot of things that broke query folding and caused slowdowns. Then one day I asked myself, why am I trying to get my data all neat in PQ? Who cares... take care of it in the visuals. But as you said, sometimes sorting is necessary to further transform your data - but apart from that, I stopped sorting and I stopped arranging columns.

Great video which clear the unclear issue of sorting and removing duplicate row to get the latest record. 👍👍

Interesting video and explanation of data compression techniques.

Excellent explanation

Thanks for the video. I was mystified why, when combining CSV files, where the primary column is consecutive days, or date and time at set intervals, the rows become jumbled up when loaded into Excel.

Awesome! Very interesting and helpful. Thanks Professor.

I have just encountered this confusion in a study of mine and now I fully understood why my data sort was overridden by excel 🫨 Thank you for the clear explanation!

Thanks, very helpful, professor. It seems to be the reason why we need Table.Buffer when Group by depends on sort order...

Interesting, thanks! I never really noticed this

'Now you understand' yeah right, this is going to take just a few more re runs.

Pls get me a Formula to count meals (breakfasts, lunches & Diners) between 2 dates in different columns i.e 20/11/2024 Diner to 24/11/24 Breakfast BF (Column) 4nos Lunch (Column) 3nos Diner (Column) 4nos If you give me a solution i will be very greatful.

You can go a step faster, put your green parameter table as one row from start, no need to transpose in PQ

Great video, thank you so much. I do have one question. If I make a Power Query Excel sheet for other people to use, would it be possible to have the outlook username & password as a parameter set in my sheet so anyone can put their info in without having to change the Query?

Great explanation, well-organized, easy to follow, nice voice.

That's very useful in Excel. Great update. Thank you for sharing it!!!

Game-changer!! Thank you so much for this easy-to-follow guide! Quick access to sorting sheets is installed and working! You have made a DIFFERENCE in my days!

THANK YOU! This was so easy to follow. I have a slightly different version of excel, but overall each step was exactly as you explained. You rock!

Thank you for sharing your knowledge.

excel DOSE add in

Great! I already had it and didn't know it till watching your video. Thanks!

Thank you for the advance notice.

Groupby function is really good and it is very helpful but it can return the values for only one column but in case in the abouve example if we need to add values for Sales amount and qty then is there any method to accomodate my requirement

Great idea

Very interesting, thanks!

Where do you find these gems?

Sometimes despite knowing certain functions you don't make use of it. You need a spark. That's what your videos do. This is a nice way to have a single pivot table and have multiple output.

Great material! The AI visuals might be useful in the future but I never use them for my reporting and rarely - if ever - see somebody using them. If at all then for training purposes only. I fear there is still long way ahead... With a specific use case maybe, other than that regular reporting still stays on top - especially with the extent for interactivity that Power BI has to offer.

Very good explanation. Excellent section on synonyms. This video is highly recommended. Thanks for sharing it, Bryon.

Detailed and solid explanation. Thanks, Professor... :)

There is no link to the example file in the video description. 🤗

Great video and download!

Awesome 😎

Very clear explanation, it has very practical use at work, thanks!!

I'm finding that it works for SOME of the quick parts, but not ALL of them. What gives?

Respected, Sir, Please make tutorial of making attendance sheet(preferably in excel 2007 version) for company working in 3 shifts(US, AUS, UK-we are in +5:30 GMT) and when an employee starts his/her shift , entry is made using ctrl+; & ctrl+shift+; , and similar log is done when he/she takes break (total 30 minutes in one day/shift ---in maximum 2 breaks ) & when completing day(8 hours). so doing 8hr continuous will make one day(7:30 hrs work and 30 minutes break). (here US(night) shift person logs in @ 8 pm on a day and leaves @4 am next day). Anything above 7:30 is counted as Overtime and added in salary at overtime rate which is specified. Can you please make video showing how to make such dashbaord or calculation sheet.PLEASE PLEASE Zohar Batterywala

nut the problem with TEXT formula is that it converts numbers into text which are then not recognised by formulas . Has any roundabout for that ??

I started to follow you only a few days ago and I've only watched a couple of videos so far. First impression: You are one of the most underrated channels on KZbin! Your way of explaining things is really great.

Hi , How can automatically click checkbox in entire raw with the colour (Blue for High & Red for Low Touch) when (( B1 is equal to C1 (High) (B1=C1)) or (( B1 is Equal to D1(Low) (B1=D1)) in first time and then I manually remove checkbox colour will disappear I AM IN STOCK MARKET SO WHEN CURRENT PRICE COME TO DAYS HIGH OR LOW SO I CAN easily FIND OUT FROM LIST thanks

Thanks a lot, I have a question unrelated to this video, how would I create a histogram in excel? At least a general formula for the table. I've tried many times and I've ended in failure and have had to do it sometimes even a bit manual. I know how to create them in r, have an idea how to create them in python, but currently in my organization I have to use excel and it's environment, and I have to use power query for mapping different data. In general it's a nightmare for me. Do you have any idea how it could be done? In any of the cases of ways, but not manual 😅, with a similar variation of steps like in r, where you alter the size of each group. For most of the things I use it for is to find year distribution of car populations. Thanks

Great explanation. I wish I had this kind of summary when I started using waterfall charts. Good hints about the colors. Professor!

awesome as always

Excellent analysis of the situation. Thanks for sharing this Waterfall.

Excellent ❤👍