Table Join - Number to Number Range

Hi sergiod04 ,

Based on your description, I have created Table A like this, Table B is the same as yours:

So you want to create Table C which is the same as your initiall expected output witout alpha numeric codes in table A, like this:

In this case, the default code column of tableA is text type, and the code start and code end columns of tableB are numeric type. Create a new calculated tableC like this:

Table C = 
ADDCOLUMNS (
    FILTER (
        ALL ( 'Table A' ),
        'Table A'[Code] >= CONVERT ( MIN ( 'Table B'[Code Range Start] ), STRING )
            && 'Table A'[Code] <= CONVERT ( MAX ( 'Table B'[Code Range End] ), STRING )
    ),
    "Category",
        CALCULATE (
            MAX ( 'Table B'[Category] ),
            FILTER (
                ALL ( 'Table B' ),
                'Table A'[Code] >= CONVERT ( 'Table B'[Code Range Start], STRING )
                    && 'Table A'[Code] <= CONVERT ( 'Table B'[Code Range End], STRING )
            )
        )
)

Attached a sample file in the below, hopes to help you.

Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.