VLOOKUP approximate match text in DAX

[Anonymous]

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.

[v-chuncz-msft · Accepted solution]

@Anonymous ,

You may refer to the post below.

https://community.powerbi.com/t5/Desktop/Lookup-Price-Range-for-Style/m-p/322514#M143719

[LivioLanzo]

Hi @Anonymous 

this is possible to do with DAX, can you post data which can be copy pasted easily?