What are Custom Functions in Power Query? How to create it?

Join this channel to get access to perks:
/ @biconsultingpro
What is a Custom Functions in Power Query? How to create it?
In this video, you'll learn about custom functions in power query. What is it and how to use it?
*****************Free Video Tutorials*************
PL-300 Sample Questions Answers: onedrive.live....
DP-203 Complete Tutorial - • DP-203: Data Engineeri...
Power BI Tutorial for Beginners: • How to get started wit... ​
Power BI Interview Questions: • Power BI Interview Que...
Power Query Tutorial: • What is Power Query? H...
Free Power BI Admin Tutorial: • How to use Power BI ad...
Free Azure Data Factory Tutorial: • Azure Data Factory | A...
Free Azure Databricks Tutorial: • Data Engineering with ...
Free Power BI Synapse Analytics Tutorial: • Microsoft Azure Synaps...
Data Modeling Tutorial: • What is Data Modeling?...
Azure Analysis Services Tutorial: • What is Azure Analysis...
Power BI Service Tutorial: • What is Power BI Servi...
Free DAX tutorial: • Complete DAX Course - ...
Field Parameters in Power BI: • May 2022 Power BI Upda...
Optimize Power BI Performance: • How to optimise Power ...
Send an e-mail alert to anyone: • How to send an Alert E...

[@daviddevita]

Hi, there! Is using a custom fuction more efficient than buidling a query or merging tables to get data?

[@daviddevita]

hi, there! Is a function faster than a query itself? What would be the difference of this method and a normal query?

[@harshgaur230506]

Thanks Ajay, for such awesome video

[@BIConsultingPro]

Glad you liked it!

[@icici244]

Hi We can copy the advance editor and same can be used right . What is the reason for creating custom function?

[@BIConsultingPro]

Good question!
However, if you’ll copy and paste each time, you need to copy and then change the file path again and again.. which is not an efficient way to do it. However, there are many other use cases where custom functions can be effective.
Moreover, it’s your choice the way you want to work.

[@SandipanSarkar-c8v]

Finished watching

[@SandipanSarkar-c8v]

Finished practicing

[@shaikhnayeem6848]

why not just duplicate the query and replace the file path, no need for parameter and custom function,,i think the above method might be better useful in other scenario..

[@SandipanSarkar-c8v]

Finished watching