Forum Discussion
Linear Interpolation From Matrix
The answer I am trying to find out is very similar to what Greg_Deckler presented on "Quick Measures Gallery" about "Linear Interpolation". Here the links: Linear Interpolation with Power Bi Li...
Thanks for your answer jthomson.
Prop_A in the Lookup table is just a referecen column. Maybe, I should have changed its name.
Basically, the value of Prop_A in the Main_Table needs to be compared with the ones in Lookup_Table to know what row we need to be in Lookup_Table.
I didn't really have time to do the complete datamodelling, but this file handles your example calculation and if you create additional columns for each of the division intervals you should get the correct result.
Take a look and see if it's along the lines of what you're thinking. If were on the right track i can fix it up and complete the remaining columns next week.
Br ,
J