Forum Discussion

AKARSEVGI's avatar
AKARSEVGI
Helper I
4 years ago
Solved

CONTAINS STATEMENT

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's avatar
    tamerj1
    4 years ago

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

1 Reply

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

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