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
jthomson's avatar
jthomson
Solution Sage
6 years ago

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

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