Advanced Pivot Table Tricks #6 - One pivot from multiple files

#PowerQuery #AppendQueries #DataModel #OnePivotTwoFiles You already know how to make a pivot from data in one file. How about creating a pivot with data from multiple files? You can use Excel Power Query to connect to multiple files and fetch the data. We can then load this data in to "Data model" and create pivot tables from it easily. For example workbook and resources visit: https://chandoo.org/wp/advanced-pivot-tables/