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...
What I'd try to do in Power Query is:
- Modify your dir column in your main table by going Number.RoundDown([Dir]/10)
- Either rename the column headers in your lookup table so that [0-10) is 0, [10-20) is 1 etc, or modify it after unpivoting it
Question then is how Prop_A works in your lookup table