by Abhijith DSouza | Jul 1, 2022 | Mining Intelligence, Power BI
0In Part 4 of the series, we talked about how to solve business problems when you want to filter a measure using numeric and date expressions. In this series, we go to the next level of business problems where we discuss problems involving % of the total. These kind...
by Abhijith DSouza | Jun 4, 2022 | Power BI
In Part 3 of the series, we talked about how to solve business problems when you want to filter a measure by attributes from the fact/dimension table and then evaluate an expression. In this series, we continue the conversation and this time we talk about how to...
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...
