Forum Discussion

adoalan's avatar
adoalan
Helper 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
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi  adoalan ,

 

Here are the steps you can follow：

1. Create calculated column.

Missing INFO =
IF(
CONTAINSSTRING([Forename],"&") =TRUE() &&CONTAINSSTRING([Surname],"&")&&'nfp_giftaiddeclaration'[Hourse]=BLANK()
,"Y","N")

2. Result:

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • adoalan's avatar
    adoalan
    Helper III
    3 years ago

    Hi Liu,

     

    Many thanks for that.

     

    Somehow is not working to me 

     

    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],