Learn Power Query | 6. Advanced Power Queries and Functions
Learn Power Query is available from:
Packt.com: https://bit.ly/2ZpbHWR
Amazon: https://amzn.to/32eOkkS
This is the “Code in Action” video for chapter 6 of Learn Power Query by Linda Foulkes, published by Packt. It includes the following topics:
00:53 Creating a parameter table for queries
02:59 Beginning with the modulo function
03:56 Understanding index functions
08:33 Appending multiple files
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:
Find us on Facebook: / packtpub
Find us on Twitter: / packtpub
Video created by Linda Foulkes