Calculated Column Find Number in Range Between two Numbers

[tim_m15]

Hi,

I have two tables.

Table A looks like this:

Number	RangeFrom	RangeTo
1	17000	17999
2	18000	18999

Table B looks like this:

Number	Name
17001	Tom
17002	Michael
19000	Brad

I want to create a calculated column in Table B that checks for each number to see if it is in the range and if so, returns a 1.

For 17001 and 17002 1 should be returned, for 19000 a 0.

Currently my calculation looks like this.

if(Table_B[Number]>=related(Table_A[RangeFrom]) && Table_B[Number]<=related(Table_A[RangeTo]) ,1,0)

Thank you for help!

[tamerj1 · Accepted solution]

Hi @tim_m15 
Please use

=
MAXX (
    FILTER (
        'Table A',
        'Table B'[Number] >= 'Table A'[RangeFrom]
            && 'Table B'[Number] <= 'Table A'[RangeTo]
    ),
    'Table B'[Name]
)

[tim_m15]

Great answer thank you!