Custom Functions Made Easy in Power BI

[@DataRambling]

Thankyou for this video. Most of the videos show how to create custom functions but do not show how to use it later. This is what I was looking for for an hour.

[@astatine0085]

This is a symphony! Thank you! I have been churning examples for hours, and I finally have my solution.

[@RADACAD]

Glad it helped!

[@AlbrechtJ]

Thanks for this hidden gems. Rarely to find someone teach this advance topic.

[@RADACAD]

Glad you enjoyed it!

[@stephencross4669]

Can’t tell you how long I looked for a video on this topic. Definitely opens the door to solving many of my problems.

[@snafuanalyst717]

Excellent tutorial on a topic that had me banging my head on my desk for years!

[@shirleysmith3409]

Thank you!! This is a wonderful video. Solved a big problem I was having with Dataflows and also improved the way I write queries.

[@jryan121]

Amazing tutorial - Cannot thank you enough for making this!

[@cleophusjohnson733]

Awesome tutorial Reza! I learned a lot!

[@curtisashley7037]

Awesome video! Instructions were crystal clear. Thank you for sharing.

[@user-hu7ov6fi9y]

Mind-blowing function. Raza, thanks for explaining this.

[@AjitUnni]

Great video, Reza. You are a natural teacher

[@alexvetrow6049]

Wow, thank you so much for this video. Now scraping websites is much easier.

[@peterh7842]

That's great - really clear but any chance of an example with more than one parameter - been requested a few times here and there are no videos on the web that I have been able to find?

[@luzernchan5691]

Hi there, thanks for the video. if I want to pass two variable into the function, what needs to be done differently ? I used the method in this tutorial, but don't seem to get it working.

[@RADACAD]

You need to add more parts in it, and add more parameters in the URL

[@not_AI_bot]

It looks like the officeholidays.com has changed their table. They removed all date. They now showing the date with format "Jan 28" without year. The problem is the auto convert to date, since it is no year, then it automatically insert the current year. Is there any easy way?

[@ivavucak9863]

Thank you for this video it is really helpful!

[@RADACAD]

Glad it was helpful!

[@kanth555]

Thanks a ton, I was searching for this technique and this helped me :-)

[@ccrosetti12]

Great video Reza - do you have a similar one but connecting to an OData source with authentication?

[@TheBirdChannelOriginal]

Great explanation!, what if I want to get the same data from Google Big query (over 100 same tables), how should I define and embed the parameter in the Advanced editor?

[@TheBirdChannelOriginal]

I could manage it by replacing date with a new parameter name. for example 20220202 should be "&NewParameter&"

[@dritans7334]

Great explanation. I have a scenario that when I try to expand and get the column I need after I invoked custom function I get this error: Expression.Error: Evaluation resulted in a stack overflow and cannot continue. Any idea how to work this around?

[@SandipanSarkar-c8v]

Finished watching

[@KerryEmerson]

Great tutorial. Does Power BI 'import' all the data specified as the source, or can this be used for dynamic API queries?

[@kaveharshadi9632]

Very useful. Thanks a lot again.

[@kennethstephani692]

This is a terrific video - very, very informative!!

[@deepaksahu3349]

Great Video, One question: If we want to fetch data for multiple countries and multiple years what we need to do ?

[@RADACAD]

you would need one parameter for the country and one for the year. However, because every country's data table format might be different you may also need a separate function for each country too.

[@PranayPawar1991]

So well explained

[@eduardodutra3294]

Thanks! You helped me a lot!

[@terpstry]

Great tutorial. Thanks

[@srinivaselluri9267]

Hi Reza, How can I translate this to Power BI online? I am able to create a invoke function with two date parameters and getting desired results in desktop. But when I publish it, I don't see that input parameter option to enter the data, Please help. Thank You

[@samama1975]

Beautiful! Thank you!!

[@novak2033]

amazing! thanks a lot!

[@phoenixflower1225]

.. Is so awesome! TY

[@doniyellin7111]

What about making a parameter that changes daily if the website also changes daily?

[@doniyellin7111]

Is there a way to automatically change the data source in PBI daily via an equation (for example: add 8340 to the middle number in the link every day. So day 1 would by 8340, day to would automatically change to 16680, etc)? Thank you!

[@kabitapaul9641]

Hi , your videos are great, those are really very helpful. I am migrating one Angular application to Power BI where I have use case like user can select which columns they want to see and the grouping columns and X axis dimension column. Data source is Snowflake (direct query) where I cannot modify the native query. "view native query" option is disabled. I was able to achieve dynamic dimension through dynamic binding of parameters. But grouping column can be one or many which I am not able to achieve. This looks very challenging and I am not sure whether it is at all possible with Power BI. I can send screenshots for the problem if you can provide any email Id.

[@CoopmanGreg]

Great Video!!

[@apodim8874]

THANK YOU!!!

[@Imrannaseem818]

Great video. Can you please make video on passing power Bi microsoft exam 70 778

[@jjpreston29]

Great video

[@SuperAzizx]

awesome

[@odel_leal]

Thank you

[@Amuppet]

You mastermind

[@powerbis.1794]

IS THIS LECTURE IN HINDI????

[@ChrisSmithFW]

Fantastic! Thank you!

[@RADACAD]

Glad you liked it!