Creating new column based on value from another table

Hi,

Please check the below picture and the attached pbix file.

expected result CC = 
SUMMARIZE (
    FILTER (
        Table1,
        Table1[START CODE] <= Table2[ID]
            && Table1[END CODE] >= Table2[ID]
    ),
    Table1[INFO]
)