Forum Discussion
Dax Formula help
Hi all, I have the above formula and I m not sure what Im doing wrong here. Can you help Thank you
I got working this part with if 3 columns are blank
Missing = IF(ISBLANK(nfp_giftaiddeclaration[Surname]) && ISBLANK(nfp_giftaiddeclaration[Forename]) && ISBLANK(nfp_giftaiddeclaration[House]), "Y", "N")
I need this part which says if nfp_declaredfore contains like '%&%' or nfp_declaredsur like '%&%' then "Y", "N")