Category: Quick Tips & Tricks

January 23, 2014

DAX – “CONTAINSX” – Finding if a value in table 1 has a matching value in table 2

Quick Tips & Tricks
January 7, 2014

Grand Total Mania! (Totals at Top & Multiple Totals)

Creative Visualizations
March 21, 2013

DAX – HASONEVALUE vs. ISFILTERED vs. HASONEFILTER

DAX
July 10, 2012

Wingdings and Other Symbolic Fonts in Slicers!

Design, Usability, and Appearance
July 5, 2012

Dynamic TopN Reports via Slicers, Part 2

DAX
June 12, 2012

DAX – Top-Selling Product using FIRSTNONBLANK()

DAX
June 7, 2012

DAX – Finding the Top-Selling Date, Product, etc.

DAX
May 29, 2012

Conditional Formatting with Different Thresholds per Test, per Product, per Store, per Division, etc.

Design, Usability, and Appearance
May 17, 2012

Excel 5-Calendar Date Table

Custom Calendars
April 24, 2012

Workarounds for “Canceled Due to Memory Pressure”

Importing Data