Forum Discussion

ezequiel's avatar
ezequiel
Microsoft Employee
8 years ago
Solved

FIND and conditional

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!

Need Help

4 Replies

  • ChrisMendoza's avatar
    ChrisMendoza
    Resident Rockstar
    8 years ago

    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's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI ezequiel

     

    Please try this

     

    Column = 
    IF(
        FIND(
            ".",
            'Table1'[Column1],
            1,
            0
            )>0 
        , "Found" 
        , "Not Found"
        )
    • ezequiel's avatar
      ezequiel
      Microsoft Employee
      8 years ago

      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