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

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?

0 5 584
5 REPLIES 5

Would you please show the existing formula

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.

Is your gender column type EnumList?

@Aleksi_Alkio Yes but [Age] is number

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

Top Labels in this Space