VLOOKUP approximate match text in DAX

I have a pivot table with a data model where I want to calculate a metric that calculates which segment a "Monthly average volume" is within. In normal Excel I use VLOOKUP and approximate match to solve it but that does not work in Power BI.

I have a main pivot table with column "Monthly average" pic 1 for which I want to add a column that states in which segment each row falls within. The segment ranges are stated in another table pic 2 . How can I define a metric that calculates this?

Note that the formula needs to be able to handle that the segments to be returned is a text not numerical.