Forum Discussion
Find UPPER except these specific values
I am using this to find improperly formatted name suffixes that are all capitalized, but I am wondering if with additional code I can filter out certain suffixes that are properly in all caps. Some e...
bhelou I get this message.
The syntax for 'AND' is incorrect. (DAX(IF ( [Suffix] = BLANK (), BLANK (), IF( EXACT(UPPER('132330'[Suffix]), '132330'[Suffix]) AND NOT(EXACT('132330'[Suffix], "JR.")), "yes", "no" ) )))
I'm also wondering how I would add multiple results to filter out in addition to the "JR." you have in the sample.