CONTAINS STATEMENT

[AKARSEVGI]

UO-SITEM KEY = IF((YEAR(RELATED('SHEAD-SALHEAD'[VALIDFROM]))<=2020) && (CONTAINS('SITEM-SALITEM','SITEM-SALITEM'[SHEAD HAKPROJECT],".S.")=TRUE() || CONTAINS('SITEM-SALITEM','SITEM-SALITEM'[SHEAD HAKPROJECT],".s.")=TRUE() ||

CONTAINS('SITEM-SALITEM','SITEM-SALITEM'[SHEAD HAKPROJECT],".")=FALSE() || ISBLANK('SITEM-SALITEM'[SHEAD HAKPROJECT]))

,'SITEM-SALITEM'[COUNTRY]&"é"&"900"

,'SITEM-SALITEM'[COUNTRY]&"é"&'SITEM-SALITEM'[SALDEPT])   -------------This query doesn't work. Is After && which has contains true? Response is COUNTRYé900 for all of <=2020.

[tamerj1 · Accepted solution]

Hi @AKARSEVGI 
Please try thr following. Also not sure if yor mean to use CONTAINS or CONTAINSSTRING, please confirm

UO-SITEM KEY =
IF (
    AND (
        YEAR ( RELATED ( 'SHEAD-SALHEAD'[VALIDFROM] ) ) <= 2020,
        CONTAINS ( 'SITEM-SALITEM', 'SITEM-SALITEM'[SHEAD HAKPROJECT], ".S." )
            || CONTAINS ( 'SITEM-SALITEM', 'SITEM-SALITEM'[SHEAD HAKPROJECT], ".s." )
            || NOT CONTAINS ( 'SITEM-SALITEM', 'SITEM-SALITEM'[SHEAD HAKPROJECT], "." )
                || ISBLANK ( 'SITEM-SALITEM'[SHEAD HAKPROJECT] )
    ),
    'SITEM-SALITEM'[COUNTRY] & "é" & "900",
    'SITEM-SALITEM'[COUNTRY] & "é" & 'SITEM-SALITEM'[SALDEPT]
)