Forum Discussion
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
3 Replies
Create New Calculate column
and try below sytax
Column = IF(('Sheet1 (2)'[Name] = "A")&&('Sheet1 (2)'[Mail ID]="[email protected]") &&('Sheet1 (2)'[Amount]>2),"Y","N")- 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
- I got thisMissing 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:
