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!
Repeating rows to create sample data II
I found another interesting and easier way to GENERATE sample data using DAX!
Change Total Row Calculation
If totals in your viz aren’t showing what you want DAX can change them.
Top Product Sales by State
Understanding the measure solution turned out to be more complex than I thought.
Troubleshoot a Measure
I’ll explain a technique I used recently to find an error in a DAX measure and a big hint that I missed!
Funnel Chart
I’m going to build a Funnel chart and recreate tooltip values using DAX measures.
Blank Row
Initially the blank row is mysterious and annoying. I’ll explain how it happens and how to work with it.
80-20 Rule
Let’s use DAX to see if transaction data adheres to the 80-20 rule.
Repeating Rows to create sample data
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.