Home

could not add the field to the pivot table because the formula is invalid

%3CLINGO-SUB%20id%3D%22lingo-sub-758030%22%20slang%3D%22en-US%22%3Ecould%20not%20add%20the%20field%20to%20the%20pivot%20table%20because%20the%20formula%20is%20invalid%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-758030%22%20slang%3D%22en-US%22%3E%3CP%3EEDIT%202%3A%20Solved%20it.%20Had%20to%20turn%20off%20grand%20totals%20on%20Pivot%20tables%20because%20it%20exceeded%20the%20character%20limit.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThis%20is%20a%20DAX%20related%20question.%20I%20am%20getting%20the%20following%20error%20when%20I%20create%20a%20measure%20that%20has%20no%20errors%20in%20the%20formula.%3C%2FP%3E%3CP%3E%22could%20not%20add%20the%20field%20fx%20Serial%20Number%20to%20the%20pivot%20table%20because%20the%20formula%20is%20invalid%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20followed%20the%20steps%20outlined%20to%20this%20article%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fpowerpivotpro.com%2F2010%2F08%2Ftwo-common-powerpivot-error-messages%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerpivotpro.com%2F2010%2F08%2Ftwo-common-powerpivot-error-messages%2F%3C%2FA%3E%3C%2FP%3E%3CP%3Eto%20try%20and%20fix%20it%2C%20however%2C%20they%20didn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20also%20getting%20issues%20where%20the%20syntax%20guide%20is%20showing%20me%20two%20different%20places%20in%20the%20syntax%20at%20once%20(see%20attached%20pictures).%20Normally%20I%20wouldn't%20think%20anything%20of%20this%2C%20but%20given%20that%20it%20isn't%20working%2C%20it%20might%20be%20significant.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20I%20can%20sort%20this%20out%2C%20it%20will%20let%20me%20put%20text%20in%20the%20value%20field%20of%20a%20pivot%20table%2C%20which%20will%20be%20HUGE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFormula%20I%20am%20using%20is%26nbsp%3B%3DCONCATENATEX%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20just%20don't%20know%20what's%20going%20wrong%20on%20this%2C%20so%20if%20any%20one%20can%20shine%20some%20light%20onto%20the%20issue%2C%20that%20would%20be%20AMAZING!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20again%20thank%20you%20so%20much!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20I%20did%20get%20it%20to%20work%20once.%20That%20spreadsheet%20is%20somewhat%20unstable%20and%20I%20cannot%20get%20it%20to%20replicate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAlso%2C%20I%20cannot%20share%20the%20spreadsheet%20because%20it%20contains%20customer%20information.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-758030%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDAX.%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Charmen85
Visitor

EDIT 2: Solved it. Had to turn off grand totals on Pivot tables because it exceeded the character limit.

 

 

Thank you in advance.


This is a DAX related question. I am getting the following error when I create a measure that has no errors in the formula.

"could not add the field fx Serial Number to the pivot table because the formula is invalid"

 

I followed the steps outlined to this article

https://powerpivotpro.com/2010/08/two-common-powerpivot-error-messages/

to try and fix it, however, they didn't work.

 

I am also getting issues where the syntax guide is showing me two different places in the syntax at once (see attached pictures). Normally I wouldn't think anything of this, but given that it isn't working, it might be significant.

 

If I can sort this out, it will let me put text in the value field of a pivot table, which will be HUGE.

 

Formula I am using is =CONCATENATEX

 

I just don't know what's going wrong on this, so if any one can shine some light onto the issue, that would be AMAZING!!!

 

Once again thank you so much!

 

EDIT: I did get it to work once. That spreadsheet is somewhat unstable and I cannot get it to replicate.

 

Also, I cannot share the spreadsheet because it contains customer information.

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies