Jul 16 2019 03:37 PM - edited Jul 16 2019 03:59 PM
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.