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?
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?
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |