Transform Stacked Column into a Table with Power Query
Data comes in countless ways and forms. Sometimes structured, with an SQL database, a table in Excel or several CVS files. The fun with Power …
Power Query
How to Group By Maximum Value using Table.Max – 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 …
How to Group or Summarize Data – 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 …
Import Multiple Files from a Folder with Power Query
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 …
