Dax formula to replicate CASE WHEN from SQL

[adoalan]

Hi,

I'm trying to replicated this CASE WHEN in Power BI and I got so far. 

can you help ?

Thank you 

[adoalan]

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:

[Satya_Bhamidipa]

Create New Calculate column
and try below sytax
Column = IF(('Sheet1 (2)'[Name] = "A")&&('Sheet1 (2)'[Mail ID]="A@gmail.com") &&('Sheet1 (2)'[Amount]>2),"Y","N")

[adoalan]

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")

I  got up to here ut still getting an error