Thank you James for your dilgent preperation, your amazing easy to folow sample files and your humor. much apreciated :)
@Franklinvaz
4 ай бұрын
Absolutely love all your videos.. most importantly your energy ❤❤❤
@jazzista1967
5 ай бұрын
HI James... Great explanation and very good case study for transforming dirty data in bulks with a custom function. I will download the file and play with it! Thanks
@whizzohk
5 ай бұрын
Wonderful - thank you! With every one of your videos I get to add another function to my repertoire - this time it's Text.AfterDelimiter, which will replace a combination of other functions I've been using to achieve the same result.
@mnowako
5 ай бұрын
WOW! Mind blowing! Thanks a lot!
@eduardomunoz2764
6 ай бұрын
Magistral, genial!.. Amazining... Thanks
@orcspkumar3999
6 ай бұрын
Your content is OSM in power query👍👍
@basensei8699
5 ай бұрын
Thanks a lot 😊
@ExcelUnlocked
6 ай бұрын
As you said, " AMAZINNNG"
@ftmagicart
6 ай бұрын
Great tutorial. Perfect technique
@basensei8699
5 ай бұрын
Thank you! Cheers!
@jerrydellasala7643
6 ай бұрын
As usual, awesome video! Could you do this again, but show how to take the original query, add a parameter inside the first "let" statement and have a second "let" statement so that a function could be created directly from the original query - the way Power Query does when you expand tables from a folder using a "Transform" query which can be easily edited to make changes to the "Transform Function"? That would be AWESOME! Thanks again.
@tonybatty504
6 ай бұрын
Lots of great tips in one focused example:)
@kebincui
6 ай бұрын
Brilliant as always 👍. Thank you James.
@Bhaskar_Joshi_there
6 ай бұрын
Loved it!
@larmondoflairallen4705
6 ай бұрын
The nested "let" thing is such an improvement over creating separate functions to handle nested table housekeeping.
@garethmorrall1047
6 ай бұрын
That was great mate thanks 👍
@Eduardoaraken
5 ай бұрын
Great! Tks to share. I wonder if this would work and how with different files in a directory to replace that “bunch” of auxiliary queries created by power query when it is the case
Пікірлер: 22