Category: Quick Tips & Tricks

August 4, 2015

So Your Detailed/Flat Pivot is Slow and Doesn’t Sort Properly? Try Text Measures!

DAX
June 11, 2015

Time to revisit the Power Pivot Import Wizard

Importing Data
March 31, 2015

DAX – The Diabolical Genius of “SWITCH TRUE”

DAX
December 9, 2014

DAX – Three Flavors of Repeat Customers

DAX
November 11, 2014

Displaying Top N, Bottom N, and “All Others”

Creative Visualizations
October 7, 2014

DAX – Blending “Time of Day” Analysis with Calendar/Date Analysis

DAX
October 2, 2014

5 Interactive Chart Techniques Come Together

Cube Formulas
August 28, 2014

Dynamic Charting In Power Pivot

Quick Tips & Tricks
August 26, 2014

DAX – SUMX of IF: A Perfect Blend of Simple & Sophisticated

DAX
August 21, 2014

DAX – The Many Faces of VALUES()

DAX