How to create functions in Power Query

[@Luke-Castellan5712]

Thanks for not editing away your mistakes! It makes me feel more normal for always needing to go through my code more than once to get it to work the way I want it to! Thanks for your videos. So informational.

[@alexkim7270]

Hey Ruth, your old videos always contain wisdoms that I'm thankful you shared them. Can you tell me the name of the part 2 of this series please? Thanks as always!

[@raitup00]

Cuando tengo un obstáculo, el algoritmo de KZbin se pone de mi lado y siempre me recomienda videos tuyos con la solución a mi problema. Increíble!

[@CurbalEN]

Cool , that is exactly why I made them :) Really happy they are useful!

[@juansepowerplatform]

great video. Thank you. I don't get to work with PowerBI any more as much as I like to, but knowing your videos are here for when I need them is amazing. Thank you

[@CurbalEN]

You dont? How come? I am Always here :) Power BI on demand! Happy Friday! /Ruth

[@juansepowerplatform]

Thanks. I been focusing on becoming good at another Microsoft product called Dynamics AX or Dynamics 365 :)

[@CurbalEN]

Oh ok, havent work with that one! Have a great weekend :) /Ruth

También lo he logrado en este, de verdad que deberían simplificar la integración de OneDrive con PowerBI. ¡Muchas gracias Ruth!

[@CurbalEN]

Yo pienso lo mismo, pero quizás no sea una prioridad para ellos ahora mismo! Ahora a descansar! /Ruth

[@squallehvonllauqs1811]

"And Voila"... Surely the cutest "Voila" ever ... The code works ! ;)

[@cooky123]

Thanks again! You've saved me. Now I have a Machine Learning API running inside PBI

[@CurbalEN]

👏👏👏 awesome! /Ruth

[@India_12321]

hi, I have some api like this "https:\\test.dev.net\fullname\tom" (tom need to be the login id of Power BI current user ie, username() ), ie "https:\\test.dev.net\fullname\"&username() how can I do this ?

[@BlauPlusServices]

Thank you Ruth for de video, in this video everything works correctly again, I mean the english subtitles. Good luck with the therapist ;-)

[@CurbalEN]

Hi 👋, I checked and I couldn’t see any differences between the videos... really weird! Glad it is working again :) /Ruth

[@JohnOttoKnoke]

Great video Ruth, I insist if you could make a video about how to share a report with external users using OneDrive.

[@CurbalEN]

Hi John, of course you may :) The videos this week and the next are already uploaded and scheduled as I am crazy busy, so I will experiment with your request hopefully week after that. If you need a faster answer, i recommend you to post on the power bi community. Take care, Ruth

[@abhilashpatel503]

Very useful one Thanks Ruth for the video can u share part 2 of the series please

[@jonmarquet]

Great job Ruth. As always.

[@CurbalEN]

Thanks Jon! :D /Ruth

[@dirksmeyers877]

Great explanation, thanks Ruth!

[@CurbalEN]

Thanks Dirk! :) /Ruth

[@soumyendupaul9556]

Good Easy to understand!! Please provide link for Part2

[@CurbalEN]

Mmmm Part 2? Is this something a mention in the video. In which minute? /Ruth

[@soumyendupaul9556]

In the first line below this video it's written 'In this video I will show you how to create a custom function in Power Query.' but video is all about parameters

[@CurbalEN]

This one? m.kzbin.info/www/bejne/d6PCl4mVpL2GhNU /Ruth

[@NorbertoVeraReatigaNVR]

Lo tenía pendiente, muy buen video, gracias Ruth!!!

[@CurbalEN]

Verdad que son útiles? :) /Ruth

[@NorbertoVeraReatigaNVR]

@@CurbalEN Sin lugar a dudas Ruth!!!

[@malchicken]

Excellent, thank you. Very helpful.

[@CurbalEN]

Glad to hear! /Ruth

[@BroadtreeSolutions]

That was excellent! Thanks Ruth

[@CurbalEN]

Thanks Mary! :) /Ruth

[@alexisroj]

Great Ruth is a good shape to re-usable on code, I going to continue using this method A++++++++++++++

[@CurbalEN]

Lo mejor que hay en el mundo :) /Ruth

[@alexisroj]

Tengo que enseñarte unos tips para usar en power BI que he aprendido usando SQL en la nube con maquinas virtuales de Google, te lo has ganado.

[@CurbalEN]

Genial 😀, ya me contarás! /Ruth

[@alexisroj]

Una observación Ruth, cuando creas los parametros te hace falta uno, el nombre de la hoja de calculo, adicionalmente que funcion cumple &em=, para yo usar archivos de OneDrive solo he estado utilizando estos dos resid= y &authkey=, nunca he tenido que tocar &em=. Si sabes para que sirve super agradecido.

[@CurbalEN]

Hola Alexis, como menciono en el vídeo, no tengo ni idea que hace el parametro em. Es posible que no haga falta? Quizás alguien aquí sabe? /Ruth

[@stevennye5075]

nice!

[@SandeepPawar1]

Good video, thanks. The little things are double quotations :)

[@CurbalEN]

😂😂 thanks! /Ruth

[@NarendraSunku]

Voice/Volume is toooo slow

[@CurbalEN]

Thanks for the feedback! /Ruth

[@gopigopichand4379]

You can watch with higher playback speed..

[@JoshuaDHarvey]

Some of your videos are much louder. This one is really quiet. Other than great video, thank you!

[@CurbalEN]

Yes, sometimes I change the setup in the audio and accidents happens :(

[@stephenphan2761]

please can you re do the voice of the video. Could not catch you up 100%

[@CurbalEN]

Have you put on the captions? That might help: m.kzbin.info/www/bejne/j5eVlIV_pbRjnM0 /Ruth

[@joserochefort7778]

if you could speak a bit louder thank you

[@davidferrick]

Horrible presentation of a basic function.

[@CurbalEN]

Thanks for the feedback David, what did you dislike so much? /Ruth

[@JohnnyTwoFingers]

How rude.

[@etbi1866]

Thank you, very informative!