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 …
Power Query
2 Tricks to Create Unique Combinations From Multiple Columns in Power Query
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
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 …
Read moreTransform Stacked Column into a Table with Power Query
Essentials for Creating a Calendar with Power Query
A calendar table is often a requirement to make a proper analysis. Whether you are trying to show year-to-date positions, moving averages, or are dealing …
Read moreEssentials for Creating a Calendar with Power Query
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 …
Read moreHow to Group By Maximum Value using Table.Max – Power Query
How to Group or Summarize Data – Power Query
Many times, Excel users need to show their data in a summarized way. Go-to tools for many are PivotTables or formulas as SUMIFS, SUMPRODUCT, AGGREGATE …
Import Multiple Files from a Folder with Power Query
In this post you will learn how to import files from a folder. Power Query makes it possible to import all Excel files from a …
Read moreImport Multiple Files from a Folder with Power Query
