Chapter 6: Advanced Power Queries and Functions
This chapter concentrates on the more advanced queries and functions in Power Query such as the IF
, Index
, and Modulo
functions. With these, you will be able to transform a range in Excel with no formatting into a highly customized table with only the relevant information that you require for your query.
You will learn to create parameters to alter query paths and append multiple files and sheet tabs. When using this, it will allow you to easily change the query paths without leaving Excel, which will then change the data source paths so every month you can add in your new data in a monthly folder and run the query instantaneously.
In this chapter, we're going to cover the following main topics:
- Writing an
IF
function in Power Query - Creating a parameter table for queries
- Creating
Index
andModulo
functions - Appending multiple files
- Appending multiple tabs