featured article
Removing Duplicates in Power Query (Complete Guide)
Latest articles
Unpivot Columns And Keep Null Values in Power Query
Unpivoting in Power Query is a way to move columns into rows. It’s simple: … Read more
Join Types in Power Query (+ Free Cheat Sheet)
Have you ever wondered how to combine tables queries or tables in Power Query? … Read more
Create Running Totals in Power Query M (Ultimate Guide)
Are you trying to create running totals in Power Query but don’t know how … Read more
The IN Operator in M / Power Query
Are you trying to use the IN operator in Power Query but don’t know … Read more
Transform Column Names in Bulk in Power Query
Are you tired of renaming columns one by one in Power Query? Do you … Read more
Demystify List.Accumulate in Power Query (Step-by-Step Guide)
Are you looking to perform an action repeatedly on your data? Power Query has … Read more
Create Date Table with Dynamic Language in Power Query
Do you want to make your data look organized and easy to understand for … Read more
Create Tables from Scratch in Power Query M (40+ Examples)
Tables have a fundamental place in Power Query. Most data transformations are based on … Read more
Get Value from Previous Row using Power Query
In this post you learn how to get the previous row value using Power … Read more
Pivot Text Values in Power Query – Explained
The above video breaks down how you can pivot text values in Power Query. … Read more
Replace Values in Power Query M (Ultimate Guide)
Replacing values is a common transformation for cleaning data. Power Query allows you to … Read more
Receive the latest article in your mailbox