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
Satya_Bhamidipa's avatar
Satya_Bhamidipa
Icon for Helper I rankHelper I
3 years ago

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

  • adoalan's avatar
    adoalan
    Icon for Helper III rankHelper III
    3 years ago
    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