Forum Discussion
arsene49
Helper I
Helper Ifind 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.
arsene49Helper I
Helper Ilbendlin 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.
lbendlin
Super User
Super UserI was just about to ask about that. There is another special scenario when the fact value matches the lookup (like for C and X).