From the course: Power BI Data Methods

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Custom functions

Custom functions - Power BI Tutorial

From the course: Power BI Data Methods

Start my 1-month free trial Buy for my team

Custom functions

“

- [Instructor] On a high level in programming function store a series of steps that we're repeating over many times. Functions typically take one or more input parameters and return a result. Like, many other facets of Power BI and Power Query, we can let the application do a lot of the work for us by tapping into built-in functionalities. Let's explore how to set up a function by using an example where Power Query automatically writes the functions for us. Let's connect to a folder of CSV files. Once we make this folder connection, we see the metadata for this folder displayed in the columns. However, we don't see the actual data. This folder option gives us an option of combining and transforming our data. Let's choose this option to see what Power Query generates for us. Now, it's worth noting that we're using a CSV connection specifically for this, and I've identified that beforehand. So let's choose one of the CSV files to use as a way to test out how the query works. This isn't…

Contents