## Category: Quick Tips & Tricks

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

Written by on March 13, 2012

### Auto-Modify Every Pivot in a Workbook

It’s been awhile since I’ve talked about Macros (also known as VBA).  I think it’s overdue. Macros are nothing short of amazing.  We couldn’t live without them at Pivotstream

Written by on March 6, 2012

### DAX – Subtotals and Grand Totals That Add Up “Correctly”

Busy week here at the MVP Summit in Redmond. As usual, I can’t tell you anything I have learned this week – it’s strictly under NDA.

Written by on March 1, 2012

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

Written by on February 7, 2012

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

Written by on January 19, 2012

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

Written by on January 12, 2012

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

Written by on January 5, 2012

### 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 Autocomplete Stops Working–A Workable “Fix”

By Now, You’ve Probably Seen This
So you’re typing along, writing a DAX measure. And suddenly, poof! Autocomplete stops working.

Written by on September 27, 2011

### Detecting ALL() – Detecting When Not Filtered

“I like to carry it, you never know when you’re gonna need it.” -The  much-missed John Candy as Uncle Buck A technique that you may need someday File this under […]

Written by on September 20, 2011

### The Incredible “Iffer-Blanker-Filter” Measure

I’ve had this on my list to share for a long time, but David Churchward’s recent guest post bubbled it to the top

Written by on September 6, 2011