Learn Power Query | 11. Creating a Basic Custom Function

Learn Power Query is available from:

This is the “Code in Action” video for chapter 11 of Learn Power Query by Linda Foulkes, published by Packt. It includes the following topics:
00:11 Changing the file path of the query to a local path
00:37 Creating the function manually
01:09 Testing the parameter function
04:09 Creating a date/time column using three M functions

This book will take you on a Power Query journey starting with shortcomings of other tools with regard to data analysis and management. Then we will delve in-depth into the Power Query interface; how to connect, combine, and refine data with really powerful query tools and learn to use the Power Query M formula language which opens up a whole new world of data mashup. We will complete the journey by creating dashboards and multi-dimensional reports in Power Query

Connect with Packt:

Video created by Linda Foulkes