Mastering DAX Calculation EDNA Training

[BrianJ]

@DMercier,

Per my earlier post, here’s our resident DAX Mozart @AntrikshSharma’s posts on context transition:

CALCULATE Mantra

Here are some steps that I recite when I am stuck with a complex problem, it is always good remember CALCULATE’s execution order. Evaluates all the filter arguments of CALCULATE in the original filter context that is active outside CALCULATE and then are kept aside CALCULATE creates a new Filter by copying the original filter context If it is called in a Row Context, either by an iterator or Calculated column then it takes that particular row and create an equivalent filter from values …

Implicit Context Transition

Until today I used to think only CALCULATE and CALCULATETABLE can do context transition but after a post by @michellepace I searched on Dax Guide and other places and I found that some other function implicitly and internally call CALCULATETABLE for context transition. Some of these functions are SAMEPERIODLASTYEAR, LASTDATE, FIRSTDATE, RELATEDTABLE, DATEADD, all the NEXT/PREVIOUS/START/END function family, internally they call CALCULATETABLE ( DISTINCT ( Dates[Date] ) ) example: LASTDATE ( C…

Context Transition - Behind the scenes

If you haven’t been living under a rock then you must be aware of Context transition, one of the most complex topics to understand and master but have you ever wondered, what actually happens behind the scenes? To be honest at least for me the behind the scene stuff is much more clear and easy to understand. Without diving too deep into theoretical aspect, If I have to explain context transition to a layman I had say take every value of all the columns of the current row in which a measure or a…

• Brian