Lookups based on date ranges
Another one from the Mr. XL Forum!
…and the word “forum” gives me an excuse for a blast from the past…
Category: DAX
DAX – Tracking Performance After an Event or Treatment
The Mr. Excel PowerPivot Forum has inspired me to change gears a little bit and focus more time on simple techniques that don’t break the DAX Spicy Scale
DAX – Comparing scientific and other data across trials
Enjoying the new forum! I’ve been spending some time on the Mr. Excel PowerPivot forum over the past few days and I must say I am enjoying the experience.
Prepayments & Deferred Revenue Using DAX
You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.
Data of Different Grains Using DAX: A Followup
Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily help you solve the “Budget vs. Actuals” problem or any other problem where you have data sets
Sales/Budget: Integrating Data of Different “Grains”
Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA
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.
Cash Flow Statement in PowerPivot
There’s few, if any, reports that I consider to be more important than the Cash Flow Statement.
DAX – The Greatest Formula in the World, Part Three
Our time machine that we developed in part one and part two still needs some explanation, so let’s dive in.
DAX – The Greatest Formula in the World, Part Two
OK, if you recall from part one, we had a “year over year” time machine calculation going on, and it was built against a data set that lacked a “real” […]
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:
DAX – Trended Moving Averages
I’ve always been a firm believer that moving averages probably give a better insight into trends within a business than a simple trend line associated to a set of values such as monthly sales