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 I...
Need Help
  • Phil_Seamark's avatar
    Phil_Seamark
    8 years ago

    HI ezequiel

     

    Please try this

     

    Column = 
    IF(
        FIND(
            ".",
            'Table1'[Column1],
            1,
            0
            )>0 
        , "Found" 
        , "Not Found"
        )
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

  • Phil_Seamark's avatar
    Phil_Seamark
    Microsoft Employee
    8 years ago

    HI ezequiel

     

    Are you trying to create a calculated column or measure?