• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Can't use table name in measure in Excel 2010 PowerPivot

J

julian excel

New Member
=SUM(Sales[ExtendedAmount]), …where "ExtendedAmount" is a column in the "Sales" table. I still get the following error message… The expression is not valid or appears to be incomplete. Please review and correct the expression. (SUM(Sales[ExtendedAmount])).

The formula works in Excel 2013. However if I omit the table name, it works.=SUM([ExtendedAmount]). But using SUMX, a table name is required. I tried re-installing PowerPivot and it's components, clearing the vertipaq temp files. But nothing works.
 
Can you upload sample? I tested on my machine and had no issue with Excel 2010.

upload_2017-2-24_11-35-43.png

Does intelli-sense give you choice, when you type partial string?
upload_2017-2-24_11-38-5.png

EDIT: You can also try nesting table name in single quote. Like below.
SUM('Sales'[ExtendedAmount])
 
Chihiro said:
Can you upload sample? I tested on my machine and had no issue with Excel 2010.

View attachment 38940

Does intelli-sense give you choice, when you type partial string?
View attachment 38941

EDIT: You can also try nesting table name in single quote. Like below.
SUM('Sales'[ExtendedAmount])
Click to expand...
Chihiro said:
Can you upload sample? I tested on my machine and had no issue with Excel 2010.

View attachment 38940

Does intelli-sense give you choice, when you type partial string?
View attachment 38941

EDIT: You can also try nesting table name in single quote. Like below.
SUM('Sales'[ExtendedAmount])
Click to expand...
It works on other computers. But not mine. But on excel 2013 it works fine. Yes intellisense gives partial string and i also tried typing with a quote.
 
Then it's not an expression issue. I'd try repairing Office installation. If that doesn't fix the issue. Try building data model from scratch on your workstation and see if same issue is replicated.
 
I have tried the following but problem still persist;
1. Office repair
2. Reinstalled component software & PowerPivot
3. Deleted vertipaq temp files.
There are a few people who have encountered the same issue but no solution so far.
 
You must log in or register to reply here.
Back
Top