Hi Gasper. Awesome tutorial! Really appreciate the detailed explanation which is so helpful when learning new techniques. Also appreciate you providing the sample data to follow along. Thanks for sharing :)) Thumbs up!!
@ExcelOlympics
3 жыл бұрын
Always a pleasure Wayne!
@K9Syndicate
Жыл бұрын
I have seen different methods of doing this, but by far yours is the best one. Thank you, and keep doing what you do.
@ExcelOlympics
Жыл бұрын
Thanks, will do!
@DK_85
3 жыл бұрын
Thanks a lot for this great video and explanation. I am a newbie in pq functions and parameter....but this helps me to understand more...
@ExcelOlympics
3 жыл бұрын
Great to hear that. One step at the time and before you know it you'll be using them everywhere.
@roderickmose4691
3 жыл бұрын
Wow. That was a great demonstration with lots of cool and interesting tips. Looking forwards to viewing more. Thumbs' up!!
@ExcelOlympics
3 жыл бұрын
Glad to hear that Roderick.
@wantanatri5919
Жыл бұрын
Thank you very much for this tutorial. I am very new to Power Query and trying to consolidate daily timesheets from multiple files. I watch many KZitem tutorial videos but nothing works until I found yours. it works like a charm :)
@ExcelOlympics
Жыл бұрын
Thank you for those kind words Wantana. Glad you got it working and even more glad that Power Query fan club has a new member 😀
@GrainneDuggan_Excel
2 жыл бұрын
Another great explanation! I have done file from folder so many times but did not realize that I could and should control so much. I never filtered for ~ before - great tip! Plan for possible variations in files - and ensure you only get the data once, but you get all of it. Thanks!
@ExcelOlympics
2 жыл бұрын
You are welcome Grainne. And aint it a great day when we learn something new in Excel.
@MaanEid
2 жыл бұрын
Great tutorial! thanks a lolt
@ExcelOlympics
2 жыл бұрын
Thanks Maan.
@alannavarrovaldez8614
3 жыл бұрын
Great video! Really like how you explain power query
@ExcelOlympics
3 жыл бұрын
Thanks Alan. Means a lot!
@Ganja1974
Жыл бұрын
wow! incredible!
@ExcelOlympics
Жыл бұрын
Thank you for those kind qwords V A. It means a lot.
@user-md7eu7dq7x
3 жыл бұрын
wonderfull!!!
@ExcelOlympics
3 жыл бұрын
Thank you.
@syedaneesdurez8766
Жыл бұрын
Amazing trick
@ExcelOlympics
Жыл бұрын
Thank you for those kind words Syed.
@GeertDelmulle
2 жыл бұрын
Hi Gasper, @ 4:22 you used a cool cursor trick! Can you tell us what app you use for that annotation? Thanks!
@ExcelOlympics
2 жыл бұрын
Hi Geert. So this is Zoom It. It's part of Sysinternals by Microsoft. It is free and requires no Installations.
@constantinrusencu3534
3 жыл бұрын
Why do you have to get the file content with a function with 2 parameters, when you can use Excel.Workbook([Content]): exceloffthegrid.com/power-query-import-all-files-in-a-folder/
@ExcelOlympics
3 жыл бұрын
I totally get what you are saying, and if all the content of the files is nothing but Sheets than what you are saying would definitely work. The problem is our custom function only works on Sheets, but far more often than not, Workbooks contain named ranges, print areas and tables along with Sheets. And that extra step is to make sure, we are feeding our function with Sheets only. Hope it makes more sense now.
Пікірлер: 28