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...
hi , try to work with switch :
SF = SWITCH(
TRUE(),
[Suffix] = BLANK(), BLANK(),
EXACT(UPPER('132330'[Suffix]), '132330'[Suffix]) && NOT(CONTAINS("JR,SR,III,IV,V", UPPER('132330'[Suffix]))), "yes",
"no"
)
bhelou I get this message: Too few arguments were passed to the CONTAINS function. The minimum argument count for the function is 3.