I want to select data from table by [gender] ...

(Chookiat Sakveerakul) #1

I want to select data from table by [gender] and between [min age] to [max age]. (the gender and age are on difference table)

but select fuction said i cannot compare Number to List. How can I make an expression correctly?

(Aleksi Alkio) #2

Would you please show the existing formula

(Chookiat Sakveerakul) #3

I use =SELECT(Talent Sheet[Talent ID], IN([Gender],[_THISROW].[Gender], AND([Age]>=Role[min Age] , [Age]<=Role[max age])))

to select Talent ID that have the same sex as in this row and have age <= min row , >= max row in Role Table.

(Aleksi Alkio) #4

Is your gender column type EnumList?

(Chookiat Sakveerakul) #5

@Aleksi_Alkio Yes but [Age] is number

(Aleksi Alkio) #6

Are you saying that you are using in this expression data from 3 different tables?