38 + Advanced Editor Keyboard Shortcuts in Power Query
Did you know there are a lot of keyboard shortcuts for the advanced editor in Power Query that can save you time? If you want …
Understanding Join Types in Power Query
In this article we delve into the different join operations you can use to merge tables in Power Query. Table joins are used to combine …
Working Days between Dates in Power Query
A common requirement is to calculate the number of working days between dates in Power Query. That means count the number of days and subtract …
Calculate Nth Business Day From Date in Power Query
You want to return the nth business day from a date in Power Query. And this offset should take into account holidays and weekends. It’s …
Compute a Running Total by Category in Power Query
This post shows how to calculate a running total by category in Power Query. A running total by category computes the cumulative sum but only …
Running Total in Power Query (Ultimate Guide)
This post shows how to easily create a running total in Power Query that performs fast. You will learn different approaches, all with their considerations. …
Return Next Working Day in Power Query
You may want to use Power Query to return the next working day in your dataset. That working day should naturally not be in the …
The IN Operator in M / Power Query
When creating conditional if statements, a common requirement is to check if a value equals one of many. In this statement you could combine multiple …
The COALESCE Operator in M / Power Query
Coalesce is an operator that allows you to return a different value instead of null. When the value on the left-hand side of the operator …
Transform Column Names in Bulk in Power Query
Knowing how to transform column names in bulk can save you a lot of manual work. This is particularly useful when you want to apply …