Forum Discussion
find the double interpolation value
you can simply add a product column to the lookup table and then use the product filter during the TREATAS lookup.
These values are perfect. thank you lbendlin
but in my case each product has different lookup tables.
In each lookup, X values are ranges same between 1 to 5 (1,2,3,4,5) but Y range varies between different product lookup.
shown example for Product B in the original message.
have added lookup's of other products here -
Lookup for Product B
| 0% | 2.06% | 4.12% | |
| 1 | 650 | 600 | 580 |
| 2 | 550 | 520 | 510 |
| 3 | 450 | 420 | 360 |
| 4 | 330 | 300 | 250 |
| 5 | 200 | 150 | 100 |
Lookup for Product C
| 0% | 3.15% | 9.46% | |
| 1 | 1500 | 1400 | 1300 |
| 2 | 1200 | 1100 | 1000 |
| 3 | 900 | 800 | 700 |
| 4 | 600 | 500 | 400 |
| 5 | 300 | 200 | 100 |
Lookup for Product D
| 0% | 2.52% | 5.04% | |
| 1 | 750 | 700 | 650 |
| 2 | 600 | 550 | 500 |
| 3 | 450 | 400 | 350 |
| 4 | 300 | 250 | 200 |
| 5 | 150 | 100 | 50 |
you can simply add a product column to the lookup table and then use the product filter during the TREATAS lookup.
- Thank you @ibendlin. this solution works perfect. if I have to do it via measure then same formula, logics and functions should work right?
you will need to describe your scenario in more detail. Measures are designed differently, you cannot easily convert the DAX for a calculated column to the DAX for a measure (especially if the business purpose is unknown).