Hello,
I'm trying to add a Calculated Item to a pivot table but get the below error when clicking on the "Calculated Item..." menu.
The table that the pivot is based on comes from a PowerQuery connection.
(If I cut and past the data into a separate sheet and (so that it's not connected to the Query) I don't get the error)
Any ideas?
The query does not load to the data model, (A PivotTable based on the "Data Model" has the Calculated Items.. menu greyed out)
Is the concept of a Calculated Item possible using DAX? (this is what I'm trying to accomplish: Pivot Table Calculated "Row" )
The item cannot be added or modified There may not be enough memory, the maximum number of items allowed in a field may have been reached, or if a Visual Basic macro is performing the operation, the macro may be incorrect.
Simplify the PivotTable report or check the macro for errors, and then try the operation again.
Thanks!
Alex
I'm trying to add a Calculated Item to a pivot table but get the below error when clicking on the "Calculated Item..." menu.
The table that the pivot is based on comes from a PowerQuery connection.
(If I cut and past the data into a separate sheet and (so that it's not connected to the Query) I don't get the error)
Any ideas?
The query does not load to the data model, (A PivotTable based on the "Data Model" has the Calculated Items.. menu greyed out)
Is the concept of a Calculated Item possible using DAX? (this is what I'm trying to accomplish: Pivot Table Calculated "Row" )
The item cannot be added or modified There may not be enough memory, the maximum number of items allowed in a field may have been reached, or if a Visual Basic macro is performing the operation, the macro may be incorrect.
Simplify the PivotTable report or check the macro for errors, and then try the operation again.
Thanks!
Alex