Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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)]
)
)
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.