Power Query Patterns


Check out our ready-to-use Power Query Patterns. Detailed instructions on how to prepare a Power Query solution with multiple use cases.

What is a Pattern?

Our patterns are a set of instructions that describe how to prepare or make something. In this case, we’re providing a set of instructions (best-practices) in order to solve common scenarios that Excel users face every day.

Power Query Patterns is a collection of these ready-to-use Power Query solutions and M scripts.

More Patterns & Tricks

More Patterns & Tricks

Get all of the workbooks used in our book for FREE!

Get More Patterns!

Suggest a New Pattern

Suggest a New Pattern

Have any cool ideas for a Power Query pattern? Leave us your thoughts about what we should work on next!

Go to Our Suggestion Box

Get the Power!

Get the Power!

Learn how to create your own Patterns or any type of Power Query solution by taking our Power Query courses.

Create your Own Pattern

Need an Instant Solution?

Need an Instant Solution?

We can respond to your requests via remote session. Sign up for our Remote Consulting service.

Contact Us

The Patterns

Click on any of the tiles and filters below to check the pattern that you're interested in
Conditional Logic
Date & Time


April 6, 2016


Dynamic Calendar Table

July 5, 2015


Merge Tables

April 6, 2015


Join our newsletter now and get a FREE copy of our eBook

'Magic Tricks for Data Wizards: TIps & Tricks for Power Query in Excel & Power BI'