P3 Adaptive
Guest post by David Churchward [Twitter] I mentioned in my LAST POST that I would return with a variation on that commission calculation. Two months later and very much overdue, […]
You may recall in my last post, COMMISSION CALCULATIONS IN POWERPIVOT, we got to the point where we could dynamically calculate the sales value and attributable commission rate that should be applied based on time, value and team parameters, reading from a Rates table.
Firstly, I have to be clear that I’m not presenting a “one-size-fits-all” approach to sales commission calculations here.
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 […]
Almost exactly six months ago, after being a long time reader of this blog, I emailed Rob and asked him a question regarding something that I just couldn’t get my head around in DAX – Banding!
You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue.
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.
There’s few, if any, reports that I consider to be more important than the Cash Flow Statement.
The first thing I ever do when I create a new PowerPivot workbook is create the date tables that I need.
If you’re anything like me, you will have eagerly sucked data into PowerPivot, keen to get cracking with solving all of your reporting needs.
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
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.