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.
You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.
I thought today was going to be a “handful of mini posts” kind of day but then this post blossomed into a bit more than I thought it would, which is a good thing.
There’s few, if any, reports that I consider to be more important than the Cash Flow Statement.
Our time machine that we developed in part one and part two still needs some explanation, so let’s dive in.
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” […]
You remember the Great Precedence Project? Well, I have shelved it for now, for two reasons:
Here’s a question that comes up with increasing frequency: “PowerPivot seems kinda similar to Access in many ways, what’s the difference?” Why Does the Question Come Up? Some of you […]
The PASS Summit tends to be one of Microsoft’s favorite venues for unveiling big news in the BI space. As you may recall, the 2010 Summit revealed some amazing things for the PowerPivot world.
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
(Rob’s note: Apologies to Colin, he put this up here in draft form weeks ago and even though I promised to flip it to live two weeks back, I forgot. So Colin… a thousand pardons. This is awesome!)
Here’s a story I find myself telling a lot these days: imagine a world in which all of today’s technology exists except spreadsheets
In my recent post, Profit & Loss-The Art of the Cascading Subtotals, I went through a basic P&L layout with some relatively complex DAX measures to display and hide row headings as appropriate together with calculating accurate values.