SUMPRODUCT with Multiple OR Criteria – Part 2/2
In previous post you learned how to combine AND and OR criteria for SUMPRODUCT. The approach results in a long and difficult to maintain formula. …
SUMPRODUCT with Multiple OR Criteria – Part 1/2
Previous posts (here and here) introduced you to filtering with SUMPRODUCT. It shows that SUMPRODUCT is a very powerful formula for filtering several AND criteria …
An Intro to Cube Functions for Power Pivot in Excel
In an earlier post I wrote about the advantages of using the Data Model in Power Pivot. Not only does it save you time by …
Read moreAn Intro to Cube Functions for Power Pivot in Excel
Change Column Type By Position in Power Query
Introduction As Power Query beginner, it is comfortable to use the user-interface to change your column names. It’s easy and quick. You double click a …
Fix Error When Reading XLSB File in Power Query
Recently one of my clients built a Power Query solution. In one of the steps, the query ran into an unknown error. The query started with …
Define Data Type While Creating Custom Column in Power Query
When working with Power Query, it is easy to end up with many applied steps. And the more applied steps your query includes, the more …
Read moreDefine Data Type While Creating Custom Column in Power Query
How to Use the Data Model in Excel
Excel can analyze data from many sources. But are you using the Data Model to make your life easier? In this post you learn how …
Split Column by Carriage Return in Power Query
Scraping content from the web is getting easier and easier. Sometimes for the data to be useful you need to break the data up into …
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
