Create a Basic Custom Function in Power Query

[@rachaelhanna8523]

This is the best explanation of a custom function I have found

[@DougHExcel]

Hi Rachael Hanna, glad you liked it, thanks for commenting!

[@ExcelWithChris]

Agree. Can we have more on just functions?

[@XxparrotBobxX]

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!

[@DougHExcel]

Hi Angel Sanchez...you're welcome, glad you liked!

[@williamarthur4801]

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.

[@DougHExcel]

Great to hear!

[@fionamehta7381]

Really easy to follow, excellent presenter, thank you for this example.

[@DougHExcel]

Hi Fiona Mehta, glad you liked it, thanks for commenting!

[@nanipandu143]

Explained very clearly.. I just started Working on power queries..this is like a kick starter.. thanks a lot

[@DougHExcel]

You’re welcome!

[@chisasukelover1]

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

[@DougHExcel]

Thanks A McDonald, glad it helped!

[@tomekkomar6313]

Super simple, clear and everything is clear. Really the essence. True. I'm impressed !!!

[@DougHExcel]

Glad u liked!

[@makisalimhussain2334]

Nice and simple approach. Thanks

[@DougHExcel]

Glad you liked it

[@simoncox4788]

Excellent Tutorial thank you

[@DougHExcel]

You’re welcome!!

[@duncanwil]

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!

[@DougHExcel]

Glad it was helpful!

[@Juan-Hdez]

Very useful. Thank you!

[@DougHExcel]

Glad it was helpful!

[@MrKirankissan]

A perfect example to get introduced to Custom Functions. Thank you

[@DougHExcel]

Hi Kiran Kissan...you're welcome, glad you liked!

[@devonmarshall2330]

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

[@archieronin8619]

@Devon Marshall instablaster :)

[@devonmarshall2330]

@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.

[@devonmarshall2330]

@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 !

[@다비드-u3y]

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?

[@DougHExcel]

It can. What’s your specific use case?

[@vhjaimes]

Very helpful Doug. Thank you!

[@DougHExcel]

Hi Victor Jaimes...you're welcome, glad you liked!

[@angelcalaguas4464]

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?

[@odel_leal]

Thank you for your help.

[@DougHExcel]

Glad it helped

[@tonytan7873]

so great! looking forward to advanced one. thx

[@DougHExcel]

Hi Tony Tan, thanks for the comment!

[@vinodkumarsingh1920]

This is the best for knowledge of the excellent.

[@DougHExcel]

Hi Vinod Kumar Singh, thanks for the comment!

[@jmo6688]

I have tons of functions, where I can export them for store or to be used or called from other excel book?

[@dflychem]

Worthwhile!

[@DougHExcel]

Hi Hisaharu Shima, thanks for the kind words!

[@SwapperTheFirst]

Excellent stuff, very practical (compared to Brian's), though he is a great explainer too.

[@DougHExcel]

Hi Vyacheslav G, glad you liked it, thanks for commenting!

[@rosabb4310]

Thank you!

[@DougHExcel]

You're welcome!

[@jdmxxx38]

A practical foray into a complex task. Nice job. Thanks for your effort.

[@DougHExcel]

You are welcome!

[@stevennye5075]

very useful!

[@DougHExcel]

Hi Steven Nye, thanks for the comment!

[@stephenphan2761]

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

[@DougHExcel]

you might want to look into Power Pivot DAX function CALCULATE --> kzbin.info/www/bejne/aqmalX-Lm5Zgqas

[@Meolimo]

tks again Doug :-)

[@DougHExcel]

You're Welcome!

[@badminton4life99]

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

[@DougHExcel]

Try extract text>> Extract Text in Power Query kzbin.info/www/bejne/qmmroYdvhZKln8k

[@thomasschneider9071]

Helped 👍

[@DougHExcel]

Hi Thomas Schneider, glad you liked it, thanks for commenting!

[@rohinibharti9727]

So I see this is from 2017, has there been updates to do the same operation faster?

[@DougHExcel]

Hi Rohini Bharti, thanks for the comment! Haven't tested lately for speed but will look into it.

[@OzduSoleilDATA]

I like this.

[@DougHExcel]

Thanks Excel On Fire!

[@wongjennifer5815]

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 ....

[@DougHExcel]

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.

[@wongjennifer5815]

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....

[@wongjennifer5815]

Hi Doug.... could you please help me....

[@rrrraaaacccc80]

💯👍

[@DougHExcel]

🙏 Thanks!

[@vkas6608]

it shows error..

[@rajeshbadola4728]

Simplified version of complicated task....

[@jmo6688]

Why we want learn new harder way to do the same things? To view on-line ad for free?