Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
Solved! Go to Solution.
@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)]
)
)
@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)]
)
)