Forum Discussion
admin11
Memorable Member
Memorable MemberHow t modify the expression to from include to exclude ?
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}, "_de...
admin11 , Try like
_delete_py =
SWITCH(
TRUE(),
NOT ('GL'[Document No.] IN {30017530,30017534,30017532}), "_delete",
BLANK()
)
amitchandak
Super User
Super Useradmin11 , Try like
_delete_py =
SWITCH(
TRUE(),
NOT ('GL'[Document No.] IN {30017530,30017534,30017532}), "_delete",
BLANK()
)