Sooner or later you’ll want to change how a visual total works. Here’s a good example.
Post Category → DAX
Counter in a visual
I heard that it’s a bad idea to add a counter inside a visual. But can I do it?
multiple date fields in fact table
A fact table can have multiple date fields. I’ve seen this in demos and wanted to practice.
Dynamic X axis on charts
Slicer value dynamically changes the x axis on a chart.
Running Total
I’ll review some basic DAX running totals (aka cumulative totals) and then various advanced examples.
Median Product Sales
Some only write measures on data they can see in tables. This is often a bad habit.
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!
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.