Hello,
One table is a "lookup" table that contains probabilities and scores. The other is a "fact" table with scores and a column for probabilities. I am looking for a DAX measure that will return the correct probability by linearly interpolating the score in the "fact" table to the "lookup" table...
<tbody>
</tbody>
<tbody>
</tbody>
One table is a "lookup" table that contains probabilities and scores. The other is a "fact" table with scores and a column for probabilities. I am looking for a DAX measure that will return the correct probability by linearly interpolating the score in the "fact" table to the "lookup" table...
Probability | Score |
.01 | 14.58 |
.02 | 12.12 |
.03 | 10.75 |
.04 | 9.83 |
.05 | 9.16 |
.06 | 8.65 |
.07 | 8.23 |
.08 | 7.88 |
.09 | 7.59 |
.10 | 7.34 |
.11 | 7.12 |
.10 | 6.93 |
<tbody>
</tbody>
IdentifierID | Group | Size | Score |
1 | A | 10000 | 9.5 |
2 | A | 8400 | 7.25 |
3 | A | 6000 | 8.499 |
4 | A | 3000 | 9.2124 |
5 | B | 4500 | 12.43 |
6 | B | 2200 | 11.689 |
7 | C | 4800 | 7.231 |
8 | C | 3300 | 8.82 |
9 | C | 8600 | 10.3 |
10 | C | 5000 | 9.9930 |
11 | D | 1100 | 10.6510 |
12 | D | 1800 | 13.4 |
<tbody>
</tbody>