Doug, this is perfect for automating repetitive tasks. i.e. I typically pull data from SQL, the date is formatted yyyymmdd, and I have to reformat as mm/dd/yyyy. Thank you!
Really good intro as for creating one using M , up to now I've only performed the actions and then changed the code in the editor to make a function, so here I've learnt something new.
Hello. Thank you very much for the wonderful video. I have one question. Is there any way to make the query table automatically pull data from a value in a new row?
sorry to be so off topic but does anyone know a method to log back into an instagram account? I was stupid forgot my login password. I would love any assistance you can give me
@Archie Ronin I really appreciate your reply. I got to the site thru google and I'm trying it out now. I see it takes a while so I will get back to you later with my results.
Wonderful lesson, Doug. How can we do Sales comparision this year vs last year by customer when we have dynamic sales revenue line by line by date. By Pivot in excel we can get tabular sheet by year in columns already but I want to see % growth by customer during the year. Ridiculously every one can do manually by copy into value and just use cell divided by cell!!! THANKS
Good video! How do I remove dash hyphen left or right of a letter, but not between numbers? 00-CM-00-12 00-C-M00-12 00CM-00-12 After transformation 00CM00-12 Thanks
Hi Doug, may i know is there any way to Transpose the Data Based on Non- Repeating Pattern in a Column in Power Query? Because I've tried your way to do it but I realised that my group of data column there are some repeating in 4 rows, some in 5 rows... so i have no choice to use ur way to do it.... please help ....
Hopefully there is a value in the end of your 4 or 5 groupings that you can make it stand out (like a zip code that is always 5 digits). Then you can create a helper column to mark those groupings. Then separate them into a list of data that is a 4 grouping and one that is a five grouping to do the transposition.
But there is a question, may i know how do I separate the group for 4 row data and 5 row data? is there any video to show that so I can easily to separate the grouping? Because I had inserted the blank row by using helper column for all 3889 row data and turn it into 22454 row data....
![[4K] Watch SpaceX Catch A Starship Rocket From Space!!! #IFT5](http://i.ytimg.com/vi/pIKI7y3DTXk/mqdefault.jpg)
This is the best explanation of a custom function I have found
Hi Rachael Hanna, glad you liked it, thanks for commenting!
Agree. Can we have more on just functions?
Doug, this is perfect for automating repetitive tasks. i.e. I typically pull data from SQL, the date is formatted yyyymmdd, and I have to reformat as mm/dd/yyyy. Thank you!
Hi Angel Sanchez...you're welcome, glad you liked!
Really good intro as for creating one using M , up to now I've only performed the actions and then changed the code in the editor to make a function, so here I've learnt something new.
Great to hear!
Explained very clearly.. I just started Working on power queries..this is like a kick starter.. thanks a lot
You’re welcome!
I finally understand what this does. And Im excited. Hope it works for my Margin thing Im doing. Even if it doesnt, Im still happy to understand now
Thanks A McDonald, glad it helped!
Hello. Thank you very much for the wonderful video. I have one question. Is there any way to make the query table automatically pull data from a value in a new row?
It can. What’s your specific use case?
I have tons of functions, where I can export them for store or to be used or called from other excel book?
Really easy to follow, excellent presenter, thank you for this example.
Hi Fiona Mehta, glad you liked it, thanks for commenting!
Hi Doug,
Can I use a list item using Invoke Custom Function? or do I need to convert the list item to a column first?
Very good! Let me admit that I forgot to add => at the end of the Let statement and that helped me to waste 15 minutes before I found out!
Glad it was helpful!
Nice and simple approach.
Thanks
Glad you liked it
Very useful. Thank you!
Glad it was helpful!
Super simple, clear and everything is clear. Really the essence. True. I'm impressed !!!
Glad u liked!
Excellent Tutorial thank you
You’re welcome!!
A perfect example to get introduced to Custom Functions. Thank you
Hi Kiran Kissan...you're welcome, glad you liked!
sorry to be so off topic but does anyone know a method to log back into an instagram account?
I was stupid forgot my login password. I would love any assistance you can give me
@Devon Marshall instablaster :)
@Archie Ronin I really appreciate your reply. I got to the site thru google and I'm trying it out now.
I see it takes a while so I will get back to you later with my results.
@Archie Ronin It worked and I finally got access to my account again. I'm so happy!
Thanks so much you really help me out !
Wonderful lesson, Doug.
How can we do Sales comparision this year vs last year by customer when we have dynamic sales revenue line by line by date. By Pivot in excel we can get tabular sheet by year in columns already but I want to see % growth by customer during the year. Ridiculously every one can do manually by copy into value and just use cell divided by cell!!!
THANKS
you might want to look into Power Pivot DAX function CALCULATE --> ruclips.net/video/4x7dLUf1-sI/видео.html
Very helpful Doug. Thank you!
Hi Victor Jaimes...you're welcome, glad you liked!
so great! looking forward to advanced one. thx
Hi Tony Tan, thanks for the comment!
Thank you for your help.
Glad it helped
Good video!
How do I remove dash hyphen left or right of a letter, but not between numbers?
00-CM-00-12
00-C-M00-12
00CM-00-12
After transformation
00CM00-12
Thanks
Try extract text>> Extract Text in Power Query
ruclips.net/video/t8HpT9P-rig/видео.html
This is the best for knowledge of the excellent.
Hi Vinod Kumar Singh, thanks for the comment!
Worthwhile!
Hi Hisaharu Shima, thanks for the kind words!
Hi Doug, may i know is there any way to Transpose the Data Based on Non- Repeating Pattern in a Column in Power Query? Because I've tried your way to do it but I realised that my group of data column there are some repeating in 4 rows, some in 5 rows... so i have no choice to use ur way to do it.... please help ....
Hopefully there is a value in the end of your 4 or 5 groupings that you can make it stand out (like a zip code that is always 5 digits). Then you can create a helper column to mark those groupings. Then separate them into a list of data that is a 4 grouping and one that is a five grouping to do the transposition.
But there is a question, may i know how do I separate the group for 4 row data and 5 row data? is there any video to show that so I can easily to separate the grouping? Because I had inserted the blank row by using helper column for all 3889 row data and turn it into 22454 row data....
Hi Doug.... could you please help me....
So I see this is from 2017, has there been updates to do the same operation faster?
Hi Rohini Bharti, thanks for the comment! Haven't tested lately for speed but will look into it.
A practical foray into a complex task. Nice job. Thanks for your effort.
You are welcome!
Excellent stuff, very practical (compared to Brian's), though he is a great explainer too.
Hi Vyacheslav G, glad you liked it, thanks for commenting!
Thank you!
You're welcome!
very useful!
Hi Steven Nye, thanks for the comment!
tks again Doug :-)
You're Welcome!
it shows error..
I like this.
Thanks Excel On Fire!
Helped 👍
Hi Thomas Schneider, glad you liked it, thanks for commenting!
Why we want learn new harder way to do the same things? To view on-line ad for free?
💯👍
🙏 Thanks!
Simplified version of complicated task....