cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
wickstromhelena Frequent Visitor
Frequent Visitor

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support Team
Community Support Team

Re: VLOOKUP approximate match text in DAX

@wickstromhelena ,

 

You may refer to the post below.

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

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 REPLIES 2
Super User
Super User

Re: VLOOKUP approximate match text in DAX

Hi @wickstromhelena 

 

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

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

Highlighted
Community Support Team
Community Support Team

Re: VLOOKUP approximate match text in DAX

@wickstromhelena ,

 

You may refer to the post below.

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

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