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"
        )
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!