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
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 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
Histogram with Power Query With the help of custom M coding, it is possible to create a frequency distribution by using power query. This is one area where Power Pivot would shine against Power Query