DAX Problem Solving

Kevin Feasel

2015-11-30

DAX

Matt Allington walks us through solving a problem using DAX:

Average of best 8 scores from last 20 rounds

So the requirement is to find the average of the best 8 scores from the last 20 rounds of golf for each player.  So if you think about that problem, there are quite a few layers to it – perfect for a blog on how to break a problem into pieces so you can solve it in DAX.

Even if you do nothing with DAX, read over the post because the problem-solving technique Allington uses is generally applicable.

Related Posts

DAX: Caching And IF Statement Optimization

Kevin Feasel

2018-06-05

DAX

Marco Russo shows us a way of improving performance on conditional statements: Consider the following measure. 1 2 3 4 5 Margin := IF (     [Sales Amount] > 0 && [Total Cost] > 0,     [Sales Amount] - [Total Cost] ) The basic idea is that the difference between Sales Amount and Total Cost should be […]

Read More

The TREATAS Function In DAX

Kevin Feasel

2017-12-07

DAX

Matt Allington explains what the TREATAS function does: The TREATAS function can be used to detect filters from your visual (filter context) and then apply these filters to a disconnected table in your data model. It takes a source table (first parameter) and applies the values from that table to columns in a target table (second […]

Read More

Categories

November 2015
MTWTFSS
« Jan Dec »
 1
2345678
9101112131415
16171819202122
23242526272829
30