DAX – The Greatest Formula in the World, Part One
You remember the Great Precedence Project? Well, I have shelved it for now, for two reasons:
Category: Precedence Project
Running Totals Without a Traditional Calendar Table
PowerPivot provides a host of great functions like DATESYTD, DATESMTD, DATESBETWEEN, etc. that are useful for calculating many things, including a running total. But with the exception of DATESBETWEEN,
DAX – Precedence Part 3: ALLEXCEPT vs. ALL w/ VALUES
This will be a quick one. I think.
In part two, we left off with the observation that VALUES() can “trump” ALL() even when VALUES() is applied to a column that is not on the pivot:
DAX – Precedence Project Part Two: VALUES()
OK, picking up from part one…
Let’s start with a simplified version of last post’s pivot – remove one of the row fields, and all of the measures but the base Total Sales measure: