Forum Discussion

ezequiel's avatar
ezequiel
Icon for Microsoft Employee rankMicrosoft 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
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

HI ezequiel

 

Please try this

 

Column = 
    IF(
        FIND(
            ".",
            'Table1'[Column1],
            1,
            0
            )>0 
        , "Found" 
        , "Not Found"
        )
  • ezequiel's avatar
    ezequiel
    Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft Employee
      8 years ago

      HI ezequiel

       

      Are you trying to create a calculated column or measure?