Using Group by to Concatenate Text in Power Query
In this post you learn how to group your data and concatenate text values. … Read more
Mastering IF Statements in Power Query – Including Nested IF-Statements
The IF function in Power Query is one of the most popular functions. It … Read more
3 Ways to SUM null values in Power Query M
Trying to sum columns with null values in Power Query but getting unexpected results? … Read more
Change Column Type By Position in Power Query
Introduction As Power Query beginner, it is comfortable to use the user-interface to change … Read more
Fix XLSB File Errors in Power Query
A XLSB File error can come to you by surprise. Recently one of my … Read more
Define Data Type While Creating Custom Column in Power Query
In this post you learn how to define a Data Type at the same … Read more
Split Column by Carriage Return in Power Query
Scraping content from the web is getting easier and easier. Sometimes for the data … Read more
Creating a Crossjoin (All Combinations) in Power Query
This post shows how to perform a crossjoin between tables in Power Query. There … Read more
2 Ways to Rank With Ties Using Power Query
Recently I worked on a challenge from Ken Puls, where I needed to figure … Read more
Transform Stacked Column into a Table with Power Query
Data comes in countless ways and forms. Sometimes structured, with an SQL database, a … Read more
Receive the latest article in your mailbox