I have a simple PowerPivot containing 2 tables. The payments table (containing many records for the claims table) holds a date value for payments. I have added 'payment date', 'payee' to the row labels, and sum of payment value to the Values. I want to display the payment date as the year only, so I created a new Measure called 'Payment Year' with the following DAX expression:
=YEAR(Payments[Date Payment Recorded])
however I continually get the error
The value for column 'Date Payment Recorded' in table 'Payments' cannot be determined in the current context.
Sorry new to PPivot and DAX! answer = Create a column on the PowerPivot tables for the year YEAR(Payments[date payment recorded]), rename the column heading and then it's available to be used in the PivotTable.
As I understand this, DAX / PowerPivot cannot GroupBy a calculated measure. I'm no expert (so may be wrong) but the calculated measures should be seen as 'Values' not for manipulating the 'grouping' etc.