Forum Discussion
Solved
Use NOT In in DAX with a variable ?
can i use not in in my DAX using a variable like
var abc = values('table 2'[number]
FILTER ('table 1 ' , NOT ('table 1 '[Number]) IN {abc} )
kumar27 Should just be:
var abc = values('table 2'[number] FILTER ('table 1' , NOT ('table 1'[Number] IN abc ))
3 Replies
kumar27 Should just be:
var abc = values('table 2'[number] FILTER ('table 1' , NOT ('table 1'[Number] IN abc ))Thanks Greg_Deckler , it wrks .
also wanted to know , we can use except also i same scenarios ?kumar27 Yes, using EXCEPT should be another way of accomplishing this.
