by Abhijith DSouza | Mar 4, 2022 | Power BI
There are several articles and books written on how to write better DAX and I have written a fair few as well. This article is not one of them. What will cover in this article are some of the best practices associated with DAX management and housekeeping before we...
by Abhijith DSouza | Feb 13, 2022 | Power BI
In the second part of the series on how to solve business problems using DAX we looked at some patterns for calculating averages different grains in the model. In this series we will look at patterns where we need sales amount filtered for a value(s) of an column of...
by Abhijith DSouza | Feb 8, 2022 | Power BI
In Part 1 of the series, we looked at some patterns to solve business problems which involved calculating total sales, maximum discount, unique products sold etc. In this Part, we will look at some patterns which involve calculating averages and also discuss some...
by Abhijith DSouza | Feb 7, 2022 | Power BI
Welcome to the first part of the series on “How to solve problems using DAX”. I spent a lot of time last year posting DAX challenges on LinkedIn which not only covered DAX functions such as CALCULATE, FILTER, TOPN, RANKX but also concepts such as context...
by Abhijith DSouza | Feb 1, 2022 | Power BI
This post is inspired by a blog in which the author showcased the visualisation of % top city sales for a region in Tableau. I thought the solution provided was cumbersome so decided to visualise it in Power BI. It turns out that the DAX for this is straightforward...
