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
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies