Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combining Columns based on text search

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

General Comment
Need Help
Tips and Tricks
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous 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)]
    )
)

2 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    4 years ago

    Anonymous 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)]
    )
)