|Learning DAX Measures – the “Spicy Function” Scale|
|Written by Rob Collie|
|Wednesday, 17 November 2010 23:42|
Is There a Preferred Way To Learn DAX Measures?
I’m glad you asked :) Actually, I do get asked this quite often – in email, on Twitter, and in person at events like last week’s PASS Summit in Seattle. I promised the folks at my Birds of a Feather lunch table that I would blog about the approach that I take in my consulting/training engagements.
I then, of course, promptly forgot. Good thing Phil reminded me today in Twitter, because it gave me an opportunity to put together that menu mockup above. Which clearly is where my time is best spent while watching Monday Night Football.
So, here it is. The official PowerPivotPro technique, refined by decades spent in the trenches of DAX. But first, some background.
- Pareto Analysis the Easy Way
- Adding a Minimum Threshold Slicer to "Stores That went negative" Technique
- Showing Only Months/Weeks/Etc. When at Least N Stores Showed a Certain Behavior
- Named Sets and "Asymmetric" Pivots: Showing Different Measures for Different Years
- Toggling Conditional Formatting On/Off via Slicer
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- How to install PowerPivot for Excel and list of know issues
- List of PowerPivot DAX functions with description
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- Learning PowerPivot and DAX
- List of PowerPivot DAX functions (short)
- PowerPivot's impact on BI pros?