# Category Archives: Power Query

## Recursive Functions in Power Query

Recursive Functions in Power Query We are all more or less familiar about recursive functions with programming languages such as Python, but what about Power Query? Can we use recursive functions with it? The answer

## Creating a 5-4-4 Calendar with Power Query

Creating 5-4-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 5-4-4. Please read here on how to use this function: Creating a 4-4-5 Calendar with

## Creating 4-5-4 Calendar with Power Query

Creating 4-5-4 Calendar with Power Query This post is a continuation of the my previous post about how to create a 4-4-5. Please read here on how to use this function: https://xcelanz.com/creating-a-4-4-5-calendar-with-power-query/ The M code

## Table.FuzzyJoin – A New Power Query Star

Power Query Table.FuzzyJoin and Table.FuzzyNestedJoin With the October 2018 release, the team at Power BI introduced two new functions in Power Query Table.FuzzyJoin and Table.FuzzyNestedJoin. These two functions essentially do the same thing, the only difference being

## Converting a Number to Roman with Power Query

Converting a Number to Roman with Power Query In this post I wanted to share my function to convert a number to Roman numerals. The function will accept any number from 1 to 3999 and

## Slow Changing Dimensions

Slow Changing Dimensions Imagine you have a simple data model like the one below composed of four tables. One fact table ( Sales ) and three dimension tables (Customers, Products, Dates).  If you wanted to

## Generate Combinations in Power Query

Generating Combinations in Power Query In this post I wanted to share the function I have created to generate combinations in Power Query. The function will accept two parameters. The first parameter is a list

## Power Query – Add blank row at each change in value

Power Query – Add blank row at each change in value This is a follow-up post to a question asked on Mr Excel forum. The OP wanted to use Power Query to add an empty