Converting from Peaks to Frequencies Using DAX
Folks I just can’t resist a quick followup on the Rat Sniffing Project. I… just… can’t. Plus I am absolutely worn down and don’t have the energy tonight for anything that isn’t inherently entertaining.
Category: DAX
Peak Detection: A Surprising Usage of DAX
In a recent post I covered a very simple scientific scenario. It was an interesting diversion from the normal biz-style scenarios but it left me feeling hollow in two ways.
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…
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” […]