Forum Discussion

adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago

Dax formula to replicate CASE WHEN from SQL

Hi,   I'm trying to replicated this CASE WHEN in Power BI and I got so far.      can you help ? Thank you 
Need Help
adoalan's avatar
adoalan
Icon for Helper III rankHelper III
3 years ago
I got this
Missing Info = IF(ISBLANK(nfp_giftaiddeclaration[Forename]) && ISBLANK(nfp_giftaiddeclaration[Surname]) && ISBLANK(nfp_giftaiddeclaration[House]) && ISBLANK(nfp_giftaiddeclaration[House]) && CONTAINSSTRING(nfp_giftaiddeclaration[Forename],"&" ) && CONTAINSSTRING(nfp_giftaiddeclaration[Surname],"&" ),"Y", "N")
 
 
but I get this error: