Sooner or later you’ll want to change how a visual total works. Here’s a good example.
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.
Unpivot Stacked Sets with varying row count
I’ve seen this in various places including Ken Pul’s blog. I wasn’t able to create a solution without rereading it so I need to practice this in detail.
Transpose & Unpivot
Why did I struggle to transpose & unpivot data in power query? I missed a couple of key concepts. I need to practice!
Reorder Columns
I didn’t realize reordering columns in Power Query could be so complicated. Thanks to Gil Raviv for his solution.
Linear Interpolation
I created a solution for linear interpolation in Power Query. Optimal? Definitely not but it works!
Median Product Sales
Some only write measures on data they can see in tables. This is often a bad habit.