Forum Discussion
Solved
find the double interpolation value
Hi All, i have a requirement to find the double interpolation value. i was able to get the logic in excel but couldn't get the same answer in powerbi there is Fact table, which has products, X,...
you can simply add a product column to the lookup table and then use the product filter during the TREATAS lookup.
lbendlin each product has different lookup tables.
In each lookup, X values are ranges same between 1 to 5 but Y range varies between different product lookup. hence shown example for Product B also in the original message.
If X/Y is outside of this loookup matrix, please take the edge point.
I was just about to ask about that. There is another special scenario when the fact value matches the lookup (like for C and X).