Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
6 years ago

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.

tex628's avatar
tex628
Community Champion
6 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Firstly, thank tex628  very much for your answer.

    I haven't had time to review it in depth yet but, difinitely, I will.

     

    However, I have seen you used both M and DAX in your approach. I will take a look and come back again.

     

    Thank you once again 🙂

     

     

    • tex628's avatar
      tex628
      Community Champion
      5 years ago

      Just me whenever you're ready! 🙂 

      Br, 
      J