Split Text After Second Value with Dax

hermanos 
It would be better  to do this in Power Query. Try this other version

NewColumn =
SWITCH (
    TRUE (),
    SEARCH ( "ships", TableName[Address],, 0 ) > 0,
        LEFT (
            TableName[Address],
            VAR aux_ =
                FIND ( "@", TableName[Address], SEARCH ( "@", TableName[Address],, 0 ) + 1, 0 )
            RETURN
                IF ( aux_ = 0, LEN ( TableName[Address] ), aux_ )
        ),
    SEARCH ( "cars", TableName[Address],, 0 ) > 0,
        LEFT (
            TableName[Address],
            VAR aux2_ =
                SEARCH ( "@", TableName[Address],, 0 )
            RETURN
                IF ( aux2_ = 0, LEN ( TableName[Address] ), aux2_ )
        ),
    TableName[Address]
)