This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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?
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.