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
PabloDeheza's avatar
PabloDeheza
Solution Sage
3 years ago

Hi adoalan !
You are not using CONTAINSSTRING correctly, as the error message says, you are providing the function more arguments than it can take. 
The funcition only works with two arguments, the first one is where it checks, and the second one is the text to look for.
Both of your CONTAINSSTRING should be closed right after "&", if you one to check for more than one string you can try with OR conditions like this:
CONTAINSSTRING( Column1, "&" ) && ( CONTAINSSTRING( Column2, "&" ) || CONTAINSSTRING( Column2, "Y" ) || CONTAINSSTRING( Column2, "N" ) )


Let me know if that helps!

adoalan's avatar
adoalan
Helper III
3 years ago

Hi Pablo,

 

Many thanks for that.

 

I m trying to match this sql formula so some are 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],