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 HAK...
  • 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]
)
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]
)