Dynamic Calendar Table
The Scenario When you are facing a scenario where you need to create a Dynamic Calendar Table (or Date Dimension Table), we take in consideration…
Author: Power Query Training
We are a team committed to delivering the best content for new and seasoned users of a tool that we believe in: Power Query. We firmly believe that this is THE best tool to be added to Microsoft Excel in a long time.
Combine or Append Data from Files
This is a sample excerpt or description which will be added as meta to the post itself and should be displayed on the "description" area and RSS feeds…
Merge Tables
The Scenario If you’ve worked with Excel for any length of time, it’s almost certain that you’ve ended up with one table that has your…
Grouping or Summarizing Data
The Scenario One of the most common request of an Excel pro is to group and summarize data. This pattern shows you how to create…