Another one from the Mr. XL Forum! …and the word “forum” gives me an excuse for a blast from the past… “What you are about to witness is real. The participants are not actors. They have agreed to dismiss their…

Guest Post by David Churchward You’ll often hear us Accountants referring to things like adjusting for timing differences or prepaying costs or deferring revenue. This is often interpreted as "massaging the numbers", but, believe me, there is a very…

Sales Measure Returns the Same Value for Everything: We Solved the Calendar/Periods Problem But Now We Have a Products/Category Problem Quick Recap: We Created a Separate “Periods” Table In last week’s post, I explained how PowerPivot can very easily…

Latest Article for CIMA Insight Some of you know that I’ve been writing a series of articles for the Chartered Institute of Management Accounts, aka CIMA. Up until this point those articles have either focused on the organizational impact,…

Guest Post by David Churchward Subtotals on or off for a field - They’re the options that you get. That’s probably great for a lot of situations, but I would put money on the majority of readers of this post…

Guest Post by David Churchward There’s few, if any, reports that I consider to be more important than the Cash Flow Statement. Every business needs one, probably above any other report. There’s numerous different versions of Cash Flow reports…

Guest post by David Churchward 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 (although…

Guest Post by David Churchward 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,…

Guest post by David Churchward 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…

Guest post by David Churchward 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…