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!!
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
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.
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!!!
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.
All your videos example explained are Amazing. Mashallah
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!
Ohhh my God! Thanks that I found you! This was I looking for the whole night! Thank you so much!
So clear and easy to follow! Thanks!
Glad it was helpful!
Brilliant! Many thanks, Nabil.
Brilliant- clever use of index.
Glad you liked it
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!
Thank you for your amazing work.
Glad you enjoy it!
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
Simple and great, thank you!
You're welcome!
This is so useful, thank you!
Glad it was helpful!
That was a brilliant video, Nabeel. Is there any way we can use our functions in PQ in other files?
Cool technique
again - great video!
Interesting solution going to the source folder twice. I like it.
Glad you like it!
New Nabil video = New jewel
Great video thanks for sharing
Thanks for watching!
Thank you very much
Marvelous video ,, great
Thanks for the visit
Thank you so much
Mr Nabil
You are most welcome
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
I cannot find the files to download, can you help me??
Good one, but need to go through again and again to understand it.
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
gold
👍👍👍🙏🙏🙏🙏💯💯💯🎉🎉🎉