Category Archives: Power BI

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

Dynamic Pareto Chart in Power BI

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 in the same Visual

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

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

Dynamic Percentiles using DAX

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 with DAX

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