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
Category Archives: Power BI
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 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
Dynamic Pareto Chart in Power BI In this post I want to share my technique of building a dynamic Pareto Chart. Pareto charts are used to show the 80/20 rule according to which roughly 80% of
Multiple Hierarchies Sometimes in Power BI you may want to build reports like the one in the screenshot below, where items are part of multiple hierarchies. You can see that items are categorized by color
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
Dynamic Percentiles using DAX Using DAX, it is not so difficult to find out who your Top 25% Customers are for a given product and what is the Sales Amount of these Top customers. Download
Correlation Matrix using DAX In this post I wanted to share one way you could calculate a correlation matrix by using DAX. I downloaded stock prices data from Yahoo for the month of September 2018
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 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