featured article
Removing Duplicates in Power Query (Complete Guide)
Latest articles
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