Forum Discussion

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

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  
Need Help
Syk's avatar
Syk
Icon for Resident Rockstar rankResident Rockstar
3 years ago

It looks like you're trying to wrap up that if statement but you're missing a ) on the last CONTAINSSTRING function.

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

    HI Syk,

     

    I added and still not working 

     

    Many thanks for that.

     

    I m trying to match this sql formula so some ae with blank and some with if contain. 

    CASE WHEN gad.nfp_declaredfore IS NULL OR gad.nfp_declaredfore = '' OR gad.nfp_declaredsur IS NULL OR gad.nfp_declaredsur = ''
    OR gad.nfp_declaredhouse IS NULL OR gad.nfp_declaredhouse = '' or nfp_declaredpostcode is null or nfp_declaredpostcode = ''
    or nfp_declaredfore like '%&%' or nfp_declaredsur like '%&%' then 'Y' ELSE 'N' END AS [Missing Info],