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: Accounting and Finance
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 – 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
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.
Profit & Loss (Part 2)–Compare and Analyse
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.
DAX – Slicers For Selecting Last “X” Periods
Using Time Intelligence in PowerPivot can appear scary when you first start using it and I’ve seen some weird and wonderful ways of attacking it, some that look like we’re calling into question the validity of the global phenomenon that is time and others that are quite simply brilliant.
Profit & Loss–The Art of the Cascading Subtotal
I occasionally look through the logs of what people were Googling (or Binging etc.) when they found their way to the blog.
- 1
- 2