
Concatenate Values in Power Query
In this article you’ll learn how to concatenate values in Power Query. If you’re … Read more

What is Power Query and How Does it Work? Beginners Guide
Looking to dive into the world of Power Query? You’re in the right place! … Read more

How to Create Today’s Date in Power Query M
Knowing how to create the current date in Power Query is invaluable for your … Read more

Generating Random Numbers in Power Query
In this article we will focus on creating random values in Power Query. We … Read more

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

Power Query Precision: Avoid Rounding Errors
Are you having trouble getting accurate results when doing calculations in Power Query? Do … Read more

Create a Fiscal Calendar in Power Query
In this article, we’ll go through the steps of creating a fiscal calendar in … Read more

Date Table with Monthly Increments in Power Query
Are you looking to create a date table with Monthly increments in Power Query? … Read more

3 Ways to Truncate Numbers (Remove Decimals) in Power Query
In this article, we’ll show you three ways to truncate numbers in Power Query … Read more

Create ISO Week and ISO Year in Power Query M (ISO 8601)
Calendars can be a real pain when analyzing your numbers. Years can start on … Read more

Creating Sequences in Power Query
Have you ever found yourself struggling to create sequences in Power Query? This article … Read more
Receive the latest article in your mailbox