Planning at the speed of COVID: P3 Adaptive and Power On
During “normal” times, you can often get away with guessing that tomorrow will resemble yesterday, and simply following your well-worn business map.
Category: Accounting and Finance
Reducing DSO using Power Pivot
One of the many things which amazes me about Power Pivot time after time is its ability to effortlessly convert raw data into crucial information as soon as it happens.
Power Pivot Cracks Direct Method Cash Flow Conundrum
Many accountants consider that cash flow statements are the most important indicator of a company’s performance, as they do not involve estimates or judgments of the preparers.
A Star (Schema) and a SWITCH for Drill-Down Income Statement Design
When I was first introduced to PowerPivot five or six years ago, I knew it would serve me well in my FP&A function.
Coffee Talk: The PowerON Pros
Welcome to the latest P3 Adaptive Coffee Talk, where members of the community discuss various topics related to Power BI, Power Pivot, and Analytics/BI in general.
Quickbooks Analysis via QQube!
For a couple years now, we’ve been quite a bit bigger than the two-person operation of our early days. Like I mentioned in a previous post, there are now somewhere between 15 and 20 people who work for us in some capacity ranging from full-time to part-time.
Tiered Commissions, Income Taxes, and other “Tiered Rate” Calculations Using DAX
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, […]
Commission Calculations using DAX Part 2
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.
Commission Calculations using DAX
Firstly, I have to be clear that I’m not presenting a “one-size-fits-all” approach to sales commission calculations here.
Aged Debtors–Dynamic Banding in DAX
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 […]
Moore’s Law and Inflation
SQL Rockstar, aka Tom LaRock (Blog | Twitter) sent me a fascinating data set the other day: a table of different computing devices over the years, their “horsepower” in calculations per second
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…
- 1
- 2