Comparing Values with No Key Fields

[RattyRattail]

I am working with two tables in Power Pivot. One is imported from a SQL query that calculates a conversion rate metric for a collections team. The other table I'm bringing in from the excel workbook itself and is a scoring matrix for the conversion rate.

An example of how these tables work together is that if agent A had a conversion rate of 48.39 % you could then look on the scoring matrix to determine that they scored a 40 out of 100. I created the scoring matrix below.

Since there really is no relationship between these two tables is there a function that I could use to see where the agent's conversion rate fell in the matrix and return the score in the other table?

From	To	Score
0	.4199	0
.42	.4299	10
.43	.4399	20
.44	.4499	30
.45	.4599	40
.46	.4699	50
.47	.4799	60
.48	.4899	70
.49	.4999	80
.50	.5099	90
.51	1	100

<tbody>
</tbody>

 

[theBardd]

Take a look at Alberto Ferrari's banding post and see if it helps Alberto Ferrari : Banding with PowerPivot

 

[RattyRattail]

Take a look at Alberto Ferrari's banding post and see if it helps Alberto Ferrari : Banding with PowerPivot

That looks to be exactly what I'm looking for. Thanks theBardd! I'll see about implementing it in my workbook.

 

[RattyRattail]

Implemented it and it was cash money. Great way to be able to dynamically work with the data using an excel table as your base banding table.