September 2010 - Posts

• PowerPivot book samples are available

  The sample files of the PowerPivot book are available at this page , where you can download a 260Mb zipped file containing all the Excel workbooks used in the book to make the examples. Read More... Posted Friday, September 24, 2010 12:55 AM by Marco Russo (SQLBI) | 0 Comments Filed under: Book, PowerPivot

• PowerPivot book RTM! And some DAX thoughts…

  Yesterday I had a nice time delivering the SQLBI Methodology session at 24 Hours of PASS . A few hours later, I had the news about the official RTM of the PowerPivot book I wrote with Alberto. The complete title is Microsoft® PowerPivot for Excel® 2010: Read More... Posted Friday, September 17, 2010 11:40 AM by Marco Russo (SQLBI) | 14 Comments Filed under: Book, DAX, PASS, PowerPivot

• Create chained relationships in PowerPivot

  If you get an error trying to create chained relationships in PowerPivot (i.e. Customers - Orders - OrderDetails), there is a known issue with a possible workaround. The item is described on Connect, but here is the issue and the workaround: ISSUE: A Read More... Posted Friday, September 10, 2010 1:03 AM by Marco Russo (SQLBI) | 1 Comments Filed under: PowerPivot