Latest Blog/Articles

May 2, 2022
A recurring problem that Power BI users find is that of incorrect totals. Here is an example: I have a table with Salespeople and their monthly sales, based on that I want to calculate their sales incentive. The sales incentive is equal to 5% of the sales if they sell more than 80k$, otherwise it’s ...
Read More
October 17, 2019
A question often asked is ’how can I do a custom sort in Power BI’. It’s a common need but its implementation is not straightforward in Power BI. In this post, I will walk you through it in the easiest possible way. As an example, I will start with a Sales table that has 3 ...
Read More
October 9, 2019
In this tutorial, I’ll walk you through the creation in Power BI of a dynamic list with the Top N products and Other. You can see the result below, where the list is filtered based on the selected month.    Load the external file in Power BI, for creating the top N table For this ...
Read More