Convert this SQL to Power BI

[adoalan]

Hi all,

I need to convert this CASE When to Power BI DAX. 

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

Many thanks in advance

[adoalan]

Hi @JorgePinho.

This is really close and makes sense. However I get this error. How to go around that

Many thanks

ADO

[JorgePinho]

Hello @adoalan !

Try this:

Missing Info = IF(ISBLANK(gad.nfp_declaredfore) || gad.nfp_declaredfore = "" || ISBLANK(gad.nfp_declaredsur) || gad.nfp_declaredsur = "" || ISBLANK(gad.nfp_declaredhouse) || gad.nfp_declaredhouse = "" || ISBLANK(nfp_declaredpostcode) || nfp_declaredpostcode = "" ||    CONTAINSSTRING( nfp_declaredfore , "&" ) || CONTAINSSTRING( nfp_declaredsur , "&" ), "Y", "N")

[adoalan]

Hello @JorgePinho, This is very close.

But I get this 

Do you see anything wrong here: (fields are a bit changed because we are migration in a different environment and names are a bit changed