PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables - TechNet Articles - Home - TechNet Wiki
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
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