Aged Debtors–Dynamic Banding in DAX
Guest post by David Churchward [Twitter] Having hit the P&L and Cash Flow in previous posts, it seems only reasonable to move on to Balance Sheet aspects. The die-hard “non-accountant” Excel […]
Category: Data Strategy
VLOOKUP Week: Who Needs VLOOKUP Anymore?
A couple of years ago at lunch, Bill remarked to me that VLOOKUP was the “scariest” feature in Excel
Moore’s Law and Inflation
SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day: a table of different computing devices over the years, their “horsepower” in calculations per second
DAX – The Correct Usage of EARLIER()
Tonight I was looking at one of my recent posts, the one about “fuzzy” time relationships in calculated columns, and I discovered that I had used the EARLIER() function in places that I did not need to.
DAX – Switching Subtotals On & Off Dynamically Using DAX in PowerPivot
In this post, I’ll explain how to create a dynamic measure that works out whether a subtotal is needed and displays that subtotal accordingly. I’ll be using the report that was created as part of the Cash Flow Statement post.
Profit & Loss (Part 3)–Return On Sales and Variances
PART 1 and PART 2 of this series on Profit and Loss posts covered the basic layout of the P&L together with some time intelligence and filtering to display relevant numbers to cover actual, budget and prior year for both a selected period and the equivalent year to date. This was all based around the core measure referred to as Cascade_Value_All.
Creating Accurate Percentile Measures in DAX – Part II
Intro from Rob: today, Colin finishes in Percentile Measures topic from last week.
Note that 1) this technique requires the new release of PowerPivot that is currently still in beta (the Denali release)…
Catching Multiple Slicer Selections in a Formula
A long time ago I did a post on using slicer selections in Excel formulas. That technique only worked when you select single values on slicers, though – any more than one and the dreaded “(Multiple items)” foils your well-laid plans.
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,
Guest Post: Catalog Your Measures with a Nifty Macro
UPDATE: Uploaded a new version of the macro file that David provided that fixed a couple of small problems. Also, I fixed a typo (I had it as XSLM, not […]
Learning DAX Measures – the “Spicy Function” Scale
“I will start with the calculate curry. And a green tea.”
-Wise first time DAX customer
Is There a Preferred Way To Learn DAX Measures?
The “Ferrari” of PowerPivot Books
UPDATE: My book, which explains the PowerPivot formula language (DAX), in down-to-earth fashion tailored to the Excel audience, releases November 6, 2012. I wrote it to fill the “DAX for Excel people” gap that existed between all of the previous books. People have been asking me seemingly forever to do this, I finally got around to it.