Mini Post #2: Mr. XL Launches PowerPivot Forum
The other day I suggested to Bill Jelen that he might want to add a PowerPivot-dedicated forum on MrExcel.com. I wasn’t sure what he would say, to be honest.
Content Type: Blog Post
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
In the Browser, Aesthetics Yield a Greater Return
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.
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 – The Greatest Formula in the World, Part Three
Our time machine that we developed in part one and part two still needs some explanation, so let’s dive in.
DAX – The Greatest Formula in the World, Part One
You remember the Great Precedence Project? Well, I have shelved it for now, for two reasons:
Using Query Editor to Create a Time Table
The first thing I ever do when I create a new PowerPivot workbook is create the date tables that I need.
SQL UNPIVOT Makes My Data Skinny
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.
Comparing Access to PowerPivot
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 […]