PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables - TechNet Articles - Home - TechNet Wiki
jueves, 12 de abril de 2012 13:59
I've been desperately trying to follow the example in this article (link above) to create a calculated field in powerpivot using the DAX formula provided "=MONTH(Sales[Sales Date])" and all I get returned is:
ERROR - CALCULATION ABORTED: MdxScript(Sandbox) (6,54) The value for column 'Sales Date' in table 'Sales' cannot be determined in the current context.
I would very much appreciate if anyone could tell me what I'm doing wrong.
I have PowerPivot installed with Office 2010 on Window XP, SP3
Todas las respuestas
jueves, 12 de abril de 2012 14:28Do you have a table named "Sales" and a column called "Sales Date" in this table?
jueves, 12 de abril de 2012 14:38
Yes. I copied the information from the table in the example and created a PowerPivot table from it and changed the name of the table to "Sales". The table "Sales" does contain a column heading "Sales Date".
lunes, 16 de abril de 2012 8:24Moderador
Please type in the expression manually, there is IntelliSense, which support for keywords, functions, columns, and measures. So I would recommend you leverage the IntelliSense to show the table's column. Do not copy it from the website, sometime, there will be some SBC (Single Byte Charactor) and DBC(Double Byte Charactor) issue.
TechNet Community Support
lunes, 16 de abril de 2012 13:46Thanks, I discovered my problem was that I was trying to enter the formula as a MEASURE rather than a formula directly into the powerpivot table.
- Marcado como respuesta Challen FuModerator martes, 17 de abril de 2012 5:39