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 …
Power Query
3 Ways to SUM null values in Power Query M
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 …
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
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 …
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 …
2 Tricks to Generate All Unique Combinations From Multiple Columns in Power Query
Power Query allows you to easily produce all value combinations from lists or columns. This can be useful for when you prepare your dataset for …
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 …
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 …
