“Relationship may be needed?” But I already have a relationship! What’s going on?


“Well I’m not quite ready for a relationship right now Lois.”

A confusing error getting you down?

I got an email this morning from a friend who was running into this problem:

PowerPivot says "Relationship may be needed" - but you do have a relationship.  What's going on?

Are you getting this warning in the field list,
even though you DO have a relationship in place?

What gives?  Let’s return to our recent movies example.

To help you diagnose this problem, should you run into it, first let’s get a simple example ready.

Two tables of data in PowerPivot:  Movies, and Years.

Read the Rest

Memorial Day Musings: The Four Team Theory


We Typically Thought of the Cold War as a Struggle Between Two Opposing Teams.
But I Now Think There Were Actually Four Opposing Teams.
(and Four Teams in Every International Struggle – Past and Present)

Continuing a holiday tradition of sorts, tonight I thought I’d share a long-simmering, Off Topic thought.  Our regularly scheduled program of Excel, PowerPivot, BI, etc. resumes Thursday.

Let’s start with a movie quote, shall we?

“Why was the gun not loaded???”


In “Elizabeth:  The Golden Age,” Spain sends an assassin to shoot Queen Elizabeth of England.
He fires, but the gun was deliberately loaded with powder only – no bullet.  Why?

Here’s one of those movies that my wife watches while I type away on my laptop and only halfway pay attention.  But boy, did this sequence get my attention.

Read the Rest

My New “Recording Studio”


The Official PowerPivotPro Sound Booth
(Yes, all Good Sound Booths Have Primus Posters)

Even though today’s post is the first time you’ve seen a video from me in a long time, I’ve actually been doing quite a bit of video recording lately – stuff that pays the bills while I spin up my new (unannounced) company, and stuff that supports the launch of said company.

Recording some guest modules for Chandoo’s PowerPivot training course is one example of this (I am finishing those today, so for those of you who enrolled, look to see those show up sometime in the next week).

As part of this process I realized that I needed a better setup for sound.  A home recording studio on the cheap. 

It wasn’t that expensive, so I thought I’d share what I got:

Read the Rest