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