Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Find upper case string in multiple columns

I learned how to use this and it works for one column.    Uppercase = IF(     EXACT(UPPER('132330'[FirstName]), '132330'[FirstName])         , "yes", "no")   Is it possible to edit it so it ...
  • v-zhangti's avatar
    v-zhangti
    3 years ago

    Hi, Anonymous 

     

    Column:

    Uppercase =
IF (
    [FirstName] = BLANK ()
        && [LastName] = BLANK (),
    BLANK (),
    IF (
        EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] )
            && EXACT ( UPPER ( '132330'[LastName] ), '132330'[LastName] ),
        "yes",
        "no"
    )
)

    Is this the result you expect?

     

    Best Regards,

    Community Support Team _Charlotte

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Super User
3 years ago

Anonymous , You have add a condition with add && , OR ||

 

example

 

IF(
EXACT(UPPER('132330'[FirstName]), '132330'[FirstName]) || EXACT(UPPER('132330'[LatsName]), '132330'[LastName])
, "yes", "no")

 

 

with and

 

IF(
EXACT(UPPER('132330'[FirstName]), '132330'[FirstName]) && EXACT(UPPER('132330'[LatsName]), '132330'[LastName])
, "yes", "no")

Anonymous's avatar
Anonymous
Not applicable
3 years ago

amitchandak can this be combined with some of this code below at the beginning to not include empty cells giving a "yes" anwser?

 

Uppercase =
IF (
[FirstName] = BLANK ()
&& [LastName] = BLANK (),
BLANK (),
IF (
EXACT ( UPPER ( '132330'[Prefix] ), '132330'[Prefix] )
&& EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] ),
"yes",
"no"
)

  • amitchandak's avatar
    amitchandak
    Super User
    3 years ago

    Anonymous , Try like

     

    Uppercase =
    Switch(True(),
    [FirstName] = BLANK ()
    && [LastName] = BLANK (),
    EXACT ( UPPER ( '132330'[Prefix] ), '132330'[Prefix] )
    && EXACT ( UPPER ( '132330'[FirstName] ), '132330'[FirstName] ),
    "yes",
    "no"
    )

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      amitchandak I get this error message:

      Function 'SWITCH' does not support comparing values of type True/False with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.