3 Ways to Add Leading Zeros to Numbers 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 …
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 …
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 …
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 …
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 …
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 …
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 …
Trying to sum columns with null values in Power Query but getting unexpected results? It is something beginners bump into all the time. And the …
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 …
In this post you learn how to define a Data Type at the same moment as you add a custom column. By default, Power Query …