Hi Nabil. Absolutely awesome! I've been searching the Internet to learn more about designing custom functions in Power Query. So, this is a very timely video for me. Your explanation is perfect.. easy to follow and understand, as well as being able to work alongside with the sample file. I can't thank you enough for sharing your knowledge and experience.. very much appreciated :)) Thumbs up!!
Many thanks Nabil, this is the best demonstration of functionalizing a query I have yet seen; the index column to handle varying numbers of rows above the data from each worksheet is fantastic.
Absolutely Brilliant! Clear and concise guidance. Presents so many ideas that I may apply to my other processes. That's what I enjoy with these applications. So many different ways of creating, managing and displaying data! I'm always willing to learn new ways (now in my mid 70s) and this has been a great example. Glad your move was a success
Hi Nabil, Thank you for the great video, but there is one thing I don't understand. In your function, there is a line where you filtered [Column14] = "Total", but this isn't always in column 14, so how does this function correctly apply this step when the other years would not have had a "Total" in column 14?
Excellent video and explanation. However, in the beginning of the video, you show that each of the year's worksheets have the actual data beginning not just in a different Row, but also a different Column. That means that the "Total" column is not always Column N (14). However, in the sample file and the function you create, you hardcode Column14 for filtering looking for the row with "Total". Can you show us how to modify the function to also make the column dynamic? Thanks!
Hi Nabil. Absolutely awesome! I've been searching the Internet to learn more about designing custom functions in Power Query. So, this is a very timely video for me. Your explanation is perfect.. easy to follow and understand, as well as being able to work alongside with the sample file. I can't thank you enough for sharing your knowledge and experience.. very much appreciated :)) Thumbs up!!
Hi Wayne, I love the dose of motivation you give me with every new tutorial. Thank you so much.
@@Officeinstructor Thanks Nabil! I appreciate all the excellent instruction :))
You are the best Nabil!!!
Many thanks Nabil, this is the best demonstration of functionalizing a query I have yet seen; the index column to handle varying numbers of rows above the data from each worksheet is fantastic.
Glad it was helpful!
Absolutely Brilliant!
Clear and concise guidance. Presents so many ideas that I may apply to my other processes.
That's what I enjoy with these applications. So many different ways of creating, managing and displaying data!
I'm always willing to learn new ways (now in my mid 70s) and this has been a great example.
Glad your move was a success
Practical real life example and easy to follow instructions. Thanks a million Nabil.
Ohhh my God! Thanks that I found you! This was I looking for the whole night! Thank you so much!
All your videos example explained are Amazing. Mashallah
Brilliant! Many thanks, Nabil.
So clear and easy to follow! Thanks!
Glad it was helpful!
Great job in demonstrating creation of power query function!!
Thank you. You are most welcome
👍👍👍...Brilliant. very useful. Thank you Nabil!
Glad you liked it!
Brilliant- clever use of index.
Glad you liked it
Thank you for your amazing work.
Glad you enjoy it!
This is so useful, thank you!
Glad it was helpful!
Simple and great, thank you!
You're welcome!
Interesting solution going to the source folder twice. I like it.
Glad you like it!
again - great video!
Cool technique
Very useful and informative 👍..... Also let us know how to do if source data is from folder and not from a single workbook
Sure I will
Thanks for the feedback
Great video thanks for sharing
Thanks for watching!
Marvelous video ,, great
Thanks for the visit
Thank you so much
Mr Nabil
You are most welcome
Thank you very much
That was a brilliant video, Nabeel. Is there any way we can use our functions in PQ in other files?
Hi Nabil, Thank you for the great video, but there is one thing I don't understand. In your function, there is a line where you filtered [Column14] = "Total", but this isn't always in column 14, so how does this function correctly apply this step when the other years would not have had a "Total" in column 14?
Nevermind, it looks like the data is always 14 columns wide since power query ignores preceding empty columns.
Help me to understand what went wrong on mine
When I hit fixing column only one was table the other were error
New Nabil video = New jewel
I cannot find the files to download, can you help me??
Excellent video and explanation. However, in the beginning of the video, you show that each of the year's worksheets have the actual data beginning not just in a different Row, but also a different Column. That means that the "Total" column is not always Column N (14). However, in the sample file and the function you create, you hardcode Column14 for filtering looking for the row with "Total". Can you show us how to modify the function to also make the column dynamic? Thanks!
ff
Good one, but need to go through again and again to understand it.
gold
👍👍👍🙏🙏🙏🙏💯💯💯🎉🎉🎉