Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
@Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Lookup-Price-Range-for-Style/m-p/322514#M143719
@Anonymous ,
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Lookup-Price-Range-for-Style/m-p/322514#M143719
Hi @Anonymous
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |