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
Power Query
Pivot Text Values in Power Query – Explained
The above video breaks down how you can pivot text values in Power Query. The regular pivoting of numbers is straight forward. But when text …
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 …
How to create a Journal Entry with Power Query
Create a journal entry using Power Query. In this post you learn how to create records, sum columns and combine datasets using Power Query. A …
Aggregate Text Values Using Group By in Power Query
Most users know the Group By function in Power Query. It allows you to summarize data and aggregate underlying values. The standard aggregations are Average, …
Read moreAggregate Text Values Using Group By in Power Query
The IF Function in Power Query: Tutorial, Example If Statements and Errors Explained (Complete Guide)
The IF function in Power Query is one of the most popular functions. It allows you to make comparisons between a value and what you’re …
3 Ways to SUM null values in Power Query
Getting unexpected results when summing up null values in Power Query is something beginners bump into all the time. And the reason for this is …
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
