Combining Columns based on text search

[gh614]

Hi all,

Could some one help me with the DAX formula below? I am trying to combine 2 columns if a column combines either of two words.

(Combined) = IF( ISERROR( SEARCH("tailored approach", SU_apps_today[(Availability)])),
(CONCATENATE(SU_apps_today[(Mortgage)], SU_apps_today[(Availability)])),
IF( ISERROR( SEARCH("exclusive", SU_apps_today[(Availability)])), (CONCATENATE(SU_apps_today[(Mortgage)], SU_apps_today[(Availability)])),
SU_apps_today[(Availability)]))

However, it just seems to combine the two columns regardless. Could someone help please.

Thanks in advance.

Glen

[gh614]

Thank you @Greg_Deckler 

[Greg_Deckler · Accepted solution]

@gh614 Maybe:

(Combined) =
IF (
    SEARCH ( "tailored approach", SU_apps_today[(Availability)], 1, BLANK() ) <> BLANK(),
    ( CONCATENATE ( SU_apps_today[(Mortgage)], SU_apps_today[(Availability)] ) ),
    IF (
        SEARCH ( "exclusive", SU_apps_today[(Availability)], 1, BLANK() ) <> BLANK(),
        ( CONCATENATE ( SU_apps_today[(Mortgage)], SU_apps_today[(Availability)] ) ),
        SU_apps_today[(Availability)]
    )
)