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: Skillwave
Your #1 resource for training on Power BI, Power Query, Power Pivot, and Excel.
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…