Create and use custom functions in Power Query (for Power BI or Excel)

This video shows you how to create and use custom functions in Power Query for Power BI or Excel.

While it uses Xero Sample data coming from OdataLink, it is also relevant for MYOB data or any other type of Power BI/Power Query/Excel development.

Intro - 0:00
Get Data - 0:30
Data Explained - 1:06
Create Parameters - 1:59
Apply Parameters - 2:32
Create the Function - 3:26
Call the Function - 3:59
Test and outro - 6:20

*About OdataLink*
OdataLink is a powerful addon for Xero and MYOB that allows you to download data directly into Power BI and Excel without the need for installing software.

Find out more about OdataLink here.