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 is one of the most popular functions. It allows you to make comparisons between a value and what you’re …
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 …
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 …
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 …
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
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 …
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
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 …
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 …
Read moreTransform Stacked Column into a Table with Power Query
