| Q: My DAX formula in the PowePivot returns error message: "The value for columns "ColumnName1" in table "Table1" cannot be determined in the current context. How can I fix this? |
| Written by Vidas Matelis |
| Wednesday, 17 March 2010 02:02 |
|
Q: My DAX formula in the PowePivot returns error message: "The value for columns "ColumnName1" in table "Table1" cannot be determined in the current context. How can I fix this? A: You can get this error message in DAX when you are adding new calculated column or when you are adding new calculated measure. If you are getting this error message when you are adding new calculated column, that means that you are referencing column "ColumnName1" from the table "Table1", but table where you adding this DAX calculated column is not related to the table "Table1". To fix this you need to create relationship between your table where you adding calculation and the table "Table1". If you are getting this error when you are adding new calculated measure (in the PivotTable interface), that means that you are using Table1[ColumnName1] column in your DAX formula, but you did not specify what type of aggregation you want to use in formula context. To fix this you should specify column aggregation function, for example: SUM(Table1[ColumnName1]).
|
Author articles
- How to solve issue when PowerPivot for Excel crashes on all workbooks
- Using PowerPivot to analyze web access log in "Combined Log" format (CLF)
- Q: I have integer amount that represents duration in seconds. How can show this amount in format "h:mm:ss"?
- Interview with Marco Russo and Alberto Ferrari about their new book about PowerPivot
- DAX cheat sheet
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
I am trying to calculate a value in the powerpivot window. I am using the following formula:
=tblDeliverable[DateSignOff])-tblRequestDetails[RequestDate]
I have changed the date fields to text, and have tried a various number of different ways to do the calculation but nothing works. There is a relationship between the two tables.
I get the same error: The value for column 'RequestDate' in table 'tblRequestDetails' cannot be determined in the current context.
=SUMX(RELATEDTABLE(ExactTableName), ExactTableName[ColumnName]).