3 Ways to Add Leading Zero to Number in Power Query
A leading zero is any 0 you add before the first nonzero digit of a string. By definition, these are invisible when a value has …
Read more3 Ways to Add Leading Zero to Number in Power Query
Function
Replace Values in Power Query – Ultimate Guide
Replacing values is a common transformation for cleaning data. Power Query allows you to easily replace values using the user interface. Yet, this is often …
Aggregate Text Values Using Group By in Power Query | Concatenate Grouped Values
Most users know the Group By functionality in Power Query. It allows you to summarize data and aggregate the grouped values. The standard aggregations are …
Read moreAggregate Text Values Using Group By in Power Query | Concatenate Grouped Values
Optimizing the performance of DISTINCTCOUNT in DAX
A common operation in Power BI is calculating the Distinct Count of a column. You may, for example, want to show the number of unique …
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. …
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 …
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 …
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 …
