## Month: October 2011

### 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.

Written by on October 27, 2011

### 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.

Written by on October 20, 2011

### 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?

Written by on October 18, 2011

### 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.

Written by on October 13, 2011

### 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.

Written by on October 11, 2011

### 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!

Written by on October 6, 2011

### Creating Accurate Percentile Measures in DAX – Part II

Intro from Rob: today, Colin finishes in Percentile Measures topic from last week.

Note that 1) this technique requires the new release of PowerPivot that is currently still in beta (the Denali release)…

Written by on October 1, 2011