FIND and conditional

[ezequiel]

Hi!

I need your help with a DAX formula for a new column. I have some names on a column with the format "firstname.lastname" and some other values with the format "firstname lastname". I need a IF formula saying that if the field contains a "." in the string, then do something and if not do something else.

I've been trying but I couldn get a result. Can you please help on this?

Thanks!

[ChrisMendoza]

hello @ezequiel,

I see you've found a solution already however, I decided to research an additional solution that I may need some day because it seems like it's only a matter of time before I need it.

Expanding on @Phil_Seamark's solution:

Column 2 = 
IF (
    FIND ( ".", Table4[Name], 1, 0 ) > 0,
    PATHITEM ( SUBSTITUTE ( Table4[Name], ".", " " ), 1 ),
    Table4[Name]
)

Thanks @Phil_Seamark for presenting your solution!

[Phil_Seamark · Accepted solution]

HI @ezequiel

Please try this

Column = 
    IF(
        FIND(
            ".",
            'Table1'[Column1],
            1,
            0
            )>0 
        , "Found" 
        , "Not Found"
        )

[ezequiel]

Hi Phil

thanks for the reply. I'm getting this error applying the formula

The syntax for '0' is incorrect.

Can you help me on this?

Thanks!

Ezequiel

[Phil_Seamark]

HI @ezequiel

Are you trying to create a calculated column or measure?