How to Use SUMPRODUCT With Multiple AND Criteria
There are situations where several criteria are required to add up the right numbers. That’s straightforward if the numbers are found in a single column …
2 Tricks to Create Unique Combinations From Multiple Columns in Power Query
There are times where you need an efficient way to produce all unique combinations of your data. Recently a customer of mine used a report …
Read more2 Tricks to Create Unique Combinations From Multiple Columns in Power Query
2 Ways to Rank With Ties Using Power Query
Recently I worked on a challenge from Ken Puls, where I needed to figure out how to Rank With Ties. Ken had a set of …
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 …
Read moreTransform Stacked Column into a Table with Power Query
Essentials for Creating a Calendar with Power Query
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
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 …
Read moreHow to Group By Maximum Value using Table.Max – Power Query
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 …
Read moreImport Multiple Files from a Folder with Power Query
Beginners Guide: How to Use the SUMPRODUCT Function in Excel
SUMPRODUCT is a multi-purpose formula. In essence, it multiplies arrays and returns the sum of those products. It is different from most Array formulas in …
Read moreBeginners Guide: How to Use the SUMPRODUCT Function in Excel
How to ROUND a Number to the Nearest 1000
Financial reports can sometimes be very messy to look at. Whereas consumers want to understand the big picture, sometimes the numbers are so detailed, they …
