Get Maximum value from a column in Table 1 that is less than value in a row from Table 2

[BRUNO1187]

I'm working with 2 tables. Table 1 is a list of building levels and their elevations. Table 2 is a list of items and their elevations. I'm trying to create a formula to identify the Maximum value from Table 1 that is less than the elevation value for each row in Table 2. I'm attempting the formula below, but I can't seem to use both tables in the same formula. I'm new to using Power BI so I'm probably going about this the wrong way. I'd appreciate any help.

elevation below = Calculate(

    Max('Table1'[ELEVATION],

    Filter('Table1',

    'Table1'[ELEVATION]<'Table2[ELEVATION]

)))

[lbendlin]

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[BRUNO1187]

Thanks, I'll try to provide a better example. I want to set up a formula to get the Maxiumum column value from Table2[Elevation] that is less than each row of Table1[Elevation], then get the corresponding Table2[Level Name] to populate the Table1[Level Below] column.

In the case of the example below, Item1, Item2, & Item3 would have "Level1" as the "Level Below". Item4, Item5, & Item6 would have "Level2" as the "Level Below". Etc.

I'd appreciate any help.

Table1

Object	Elevation	Level Below
Item1	8	<get from Table2>
Item2	9	<get from Table2>
Item3	7	<get from Table2>
Item4	15	<get from Table2>
Item5	16	<get from Table2>
Item6	18	<get from Table2>
Item7	27	<get from Table2>
Item8	27	<get from Table2>
Item9	38	<get from Table2>
Item10	49	<get from Table2>

Table2

Level Name	Elevation
Level1	0
Level2	10
Level3	20
Level4	30
Level5	40

Table1 (EXPECTED OUTCOME)

Object	Elevation	Level Below
Item1	8	Level1
Item2	9	Level1
Item3	7	Level1
Item4	15	Level2
Item5	16	Level2
Item6	18	Level2
Item7	27	Level3
Item8	27	Level3
Item9	38	Level4
Item10	49	Level5