POWER BI DESKTOP ICON HOW TO
POWER BI DESKTOP ICON UPDATE

Our main query is a query that will be repeated later on by calling from other queries. Building the Main QueryДЇor creating a custom function you always need to build a main query and then convert that to a function. We want the process to be dynamic, so if a new yearвЂ™s data appear in that page, that will be included as well. This example is fetching all public holidays from the website above, and appending them all in a single table in Power Query.

POWER BI DESKTOP ICON HOW TO

Through an example IвЂ™ll show you how to create a custom function. Recently Power BI Desktop changed a lot, you can now create a function without writing any single line of code. Previously (about a year ago), creating custom functions was only possible through M scripting, with lambda expressions, that method still works, but you need to be comfortable with writing M script to use that method (To be honest I am still fan of that method рџ‰ ). Well, thatвЂ™s the question I want to answer in this post. and you are reducing redundant steps which normally causes extra maintenance of the code.

You can call this function from everywhere in your code.

If you want to change part of it, there is only one place to make that change, instead of multiple copies of that. With a Custom function you are able to re-use a query multiple times. Here is where Custom Function comes to help. Then you probably want to apply same steps on all other pages for other years (2015, 2017, 2018вЂ¦), So instead of repeating the process you can reuse an existing query. You can also make some changes in the date format to make it proper Date data type. You can simply use Power BI Get Data from Web menu option of Power Query to get the public holidays of this page. here is for example public holidays of 2016:

LetвЂ™s see that as an example: Website below listed public holidays in New Zealand:ДЇor every year, there is a page, and pages are similar to each other, each page contains a table of dates and descriptions of holidays. The main benefit of having a query to run by other queries is that you can repeat a number of steps on the same data structure. What is Custom Function?Д¬ustom Function in simple definition is a query that run by other queries. If you like to learn more about Power BI read Power BI online book from Rookie to Rock Star. In this blog post you will learn how easy is to create a custom function now, what are benefits of doing it in this way, and limitations of it.

POWER BI DESKTOP ICON UPDATE

This started with bringing Parameters few months ago, and adding source query for the function in November update of Power BI Desktop. With recent updates of Power BI Desktop, creating custom functions made easier and easier every month. I have written a lot about Power Query M scripting language, and how to create custom functions with that.

Power bi desktop icon