Tiered Pricing Lookup based on Scenario


I have the following pricing table in PBI:


I also have a scenario (parameters) tool that I am using to adjust the “Qty”. I’m trying to calculate a measure “Price per Month” based on the quantity I select with the scenario tool. I only want to return the “per unit cost” in this measure based on the qty. I don’t want to calculate the total cost. So basically with my scenario slider if I select:

Qty < 2 = $2000
Qty 3 -5 = $1500
Qty =>6 = $1250

Hope that is clear.


You could use a SWITCH statement. Here is a video from Sam that will explain it more if you are not familiar with it.