We are doing a series of Office 2010 interviews on June 1st and 2nd and I want to make sure we ask the right questions. Is there anything you would like to know or like us to ask about Power Pivot in Excel 2010? Thanks in advance.
Are there any advantages to querying against R2 vs 2008 RTM? Also, is it possible to get multiple PowerPivots into a single workbook? And where should I go to learn the in-and-outs of
And why do I get a "The value for column 'item_pack' in table 'Table_on_Items' cannot be determined in the current context.", when I create a calculated column "=Query[bottles]/Table_on_items[item_pack]"? I created the relations, and that seemed to be a
no-brainier. Table_on_item is a linked table and Query is a SQL query.
Even after the releationship is created, when I try to create a non-compound measure
I get: The column 'table_on_items[item_pack]' either doesn't exist or doesn't have a relationship to any table available in the current context.
Edit: First I had to create the column item_pack on my Query table, within PowerPivot, using Related. Then I was able to create a column named cases, where cases = bottles / item_pack. I would say that something should kick-in
and tell you to use the related function when it looks like you are trying to do something obvious that doesn't work.
Everything else is surprisingly quick, even with 30 million rows.
Comments have been closed since this content was published more than 30 days ago, but if you'd like to continue the conversation, please create a new thread in our Forums, or Contact Us and let us know.