PowerPivot: Grouping By Dates (Months, Quarters, Years, etc.) in PivotTables - TechNet Articles - Home - TechNet Wiki

Question

http://social.technet.microsoft.com/wiki/contents/articles/1018.powerpivot-grouping-by-dates-months-quarters-years-etc-in-pivottables.aspx

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

Answer 1

Do you have a table named "Sales" and a column called "Sales Date" in this table?

---

Javier Guillen
http://javierguillen.wordpress.com/

Answer 2

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".

Answer 3

Hi hwm8178,

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.

Thanks,

---

Challen Fu

TechNet Community Support

Answer 4

Thanks, 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.