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 Two
OK, if you recall from part one, we had a “year over year” time machine calculation going on, and it was built against a data set that lacked a “real” […]
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 […]
The Ultimate Date Table
I get a lot of questions from people who are struggling with the time intelligence functions in DAX.
Six Observations from the 2011 PASS Keynote
The PASS Summit tends to be one of Microsoft’s favorite venues for unveiling big news in the BI space. As you may recall, the 2010 Summit revealed some amazing things for the PowerPivot world.
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
Mini-Post 3/4: DAX.xml Update for Notepad++ from Colin Banfield
(Rob’s note: Apologies to Colin, he put this up here in draft form weeks ago and even though I promised to flip it to live two weeks back, I forgot. So Colin… a thousand pardons. This is awesome!)
What if spreadsheets were invented today?
Here’s a story I find myself telling a lot these days: imagine a world in which all of today’s technology exists except spreadsheets
