Context Transition

I’ve practiced context transition a lot recently. I’ll review what I’ve learned and revisit the theory from book ‘The Definitive Guide to DAX’.

Learning DAX by experimentation

1st: a vague requirement that needs clarifying. 2nd: a puzzle to solve via a journey of DAX discovery!

I found another interesting and easier way to GENERATE sample data using DAX!

If totals in your viz aren’t showing what you want DAX can change them.

Understanding the measure solution turned out to be more complex than I thought.

I’ll explain a technique I used recently to find an error in a DAX measure and a big hint that I missed!

I’m going to build a Funnel chart and recreate tooltip values using DAX measures.

Initially the blank row is mysterious and annoying. I’ll explain how it happens and how to work with it.

Let’s use DAX to see if transaction data adheres to the 80-20 rule.

Contoso seems to be the standard Power BI sample data-set. However, I find it helpful to use a smaller data-set when learning a concept.