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
Tag 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
When you need to download financial data to use into Power BI, searching for the right website or API can be a daunting task. Luckily, thanks to Python and its support into Power BI, it
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