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.
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).