A calendar table is often a requirement to make a proper analysis. Whether you are trying to show year-to-date positions, moving averages, or are dealing …
Read moreEssentials for Creating a Calendar with Power Query
In an earlier article, I showed a basic example of how to group data. The grouping functionality takes your data, let’s you perform some operations with …
Read moreHow to Group By Maximum Value using Table.Max – Power Query
Many times, Excel users need to show their data in a summarized way. Go-to tools for many are PivotTables or formulas as SUMIFS, SUMPRODUCT, AGGREGATE …
In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a …
Read moreImport Multiple Files from a Folder with Power Query
