Two common PowerPivot error messages

Been meaning to post this for awhile now. Here are two error messages I see all the time now, about once per day: UPDATED:  I’ve found a third message that belongs in this same family, with same root cause and same fix, now included below. I typically get the first when I’m adding a measure, the second when I am trying to put a field on a slicer, and the third when I am adding a field from a table…

Read the Rest

An XL Pro’s Plea for More XL Pro-Focused Content

  “Don’t you, forget about me.” -Excel Pros Everywhere From the beginning I’ve been talking about three different kinds of PowerPivot professionals:  Excel pros, SharePoint pros, and Database pros, and how they will all need to cooperate in order to get the most out of the system. As far as I can tell, though, the majority of visitors to this site are from the Database camp (I lump Business Intelligence pros into this bucket).  Not surprising perhaps, since PowerPivot is…

Read the Rest

Building a cash flow statement in PowerPivot using dynamic measures in DAX

Posted by Kasper de Jonge UPDATE FROM ROB:  You can now find all kinds of Accounting and Financial Techniques filed under a category created specifically for them.  To view those posts click here: http://www.powerpivotpro.com/category/accountingfinancial-techniques/ Also, there is now also ANOTHER in-depth example of cash flow statements here: http://www.powerpivotpro.com/2011/12/cash-flow-statement-in-powerpivot/  (Now, back to Kasper's excellent post) I got an excellent question at my "Ask a question page" on my blog. Greg asked me if i knew of a sample for a cash…

Read the Rest

Kasper de Jonge joins PowerPivotPro!

  “Hey!  Where’d you get that pic??” -Kasper “The Killer Ghost” de Jonge Guest Poster Becomes Co-Owner! Over the past few months, Kasper has provided a number of excellent guest posts – the most prolific guest poster in this blog’s short history in fact. I have to wait until next week to find out exactly how good Kasper is at hoops.  But I already know he plays a mean game of PowerPivot.  In fact he plays a mean game of……

Read the Rest

Up for air… briefly

  “A little less blogger nation, a little more action please.” -The King Folks, I’ve been up to my eyeballs in PowerPivot these days.  Which ironically has resulted in less writing about PowerPivot. Quite simply, the release of PowerPivot v1 to MSDN was like a huge starting gun going off.  Suddenly, all that theory became “ok, let’s put it into practice…  on 10 different fronts.” I’ve been on so many exciting phone calls and web meetings lately.  Lots of very…

Read the Rest

I thought this was kinda cool…

Check out what happens if you start to type “PowerPivot” into Google’s search box these days: Very gratifying, for sure.  Thanks folks, this feels good. (I won’t comment on Bing, which clearly favors the blogs of current MS employees - cough cough PowerPivotGeek cough cough) What I’ve Been Doing, What I Will Talk About Next Maurice Prather and I have been heads-down this week getting PivotStream’s server farm up to date with SharePoint and PowerPivot RTM.  Four servers working together…

Read the Rest

May 12th in NYC: “IT Can’t Hide from MS Excel”

Quick tip:  if you live in the New York City area, I highly recommend looking into this session on May 12th: http://tdwichapters.org/Blogs/New-York/2010/04/May-12th-2010-IT-Can-Run-But-IT-Cant-Hide-from-MS-Excel.aspx It features Bill Baker and Andrew Brust.  I worked with Bill Baker at Microsoft while he ran the Business Intelligence arm of SQL.  Very colorful guy with an illustrious history and a reputation for not pulling punches. I’ve never met Andrew personally but he was one of the first people I “met” on Twitter, and I quickly came…

Read the Rest