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
Profit & Loss (Part 3)–Return On Sales and Variances
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.
Profit & Loss (Part 2)–Compare and Analyse
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 calculating accurate values.
Adding State Alpha Sort to the Sort By Slicer Trick
Sorting by State! How did I miss that? In a comment on Thursday’s post, Janet asked an excellent question: what about sorting by state name?
User-Friendly Report Sorting With Slicers!
Let’s say you are a monster Excel pro. You’re a pivot master. Nothing is beyond you – even the more complex features of Excel seem easy.
DAX – Slicers For Selecting Last “X” Periods
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 validity of the global phenomenon that is time and others that are quite simply brilliant.
PowerPivot ROI Comparison: CIMA Part Three
It’s that time of the month again folks… you know… for the next installment in my series for CIMA Insight!
