Table of Contents

  • The DAX Auto Snapshot (Part 2): Copy, Lookup, and Filter

    In the last post we learned that when you see the name of a Model Table in your code the mental picture you draw in your head of that thing is probably incorrect. So in the following code: The reference to “Sale” will make you want to envision the Sale table that you loaded into…

    Read more

  • The most important skill in DAX is Table Vision. Table Vision is being able to look at your code and envision what tables you are asking DAX to create, and what you are asking it to do with them. Not just describe them, but *see* them in your mind’s eye. The stronger your Table Vision…

    Read more

  • In the previous two posts we learned about the two most common kinds of column references in DAX, the Current Row Reference, and the Model Column Reference. In this post I’m going to both focus on why this so frustrating for new DAX authors, and also spend some time helping you be able to start…

    Read more

  • In the last post we learned that a column reference can be interpreted one of three ways depending on where it’s being made: With the first two on the list being the most important to understand because they are the ones new DAX authors will encounter with the greatest frequency. We also learned that all…

    Read more

  • In the following three posts I’m going to focus on a topic that you run into every day but probably don’t think much about. It’s pretty important though and worth exploring thoroughly. Whenever you create a column reference in DAX like: Sale[Qty] It can actually have one of three kinds of meanings depending on *where*…

    Read more