How t modify the expression to from include to exclude ?

[admin11]

Hi All

Below expression working fine , which filter 3 number from GL Table base on Document No. field  :-

_delete =

SWITCH(

TRUE(),

'GL'[Document No.] IN {30017530,30017534,30017532}, "_delete",

BLANK()

)

May i know how to modify the above to ex-clude these 3 number ? I have try :-

_delete_py =

SWITCH(

TRUE(),

'GL'[Document No.] NOT IN {30017530,30017534,30017532}, "_delete",

BLANK()

)

[amitchandak · Accepted solution]

@admin11 , Try like

_delete_py =

SWITCH(

TRUE(),

NOT ('GL'[Document No.] IN {30017530,30017534,30017532}), "_delete",

BLANK()

)