Help calculating a cost per piece calculation using a Cost per mile rate that changes each quarter

[JeffH]

Need to show cost per piece using a Quaterly changing Cost per Mile Table 

(Cost per piece = miles*Cost per Mile/Pieces)

I have a total miles measure and a total pieces measure. 

Here is my table. I need two additional columns showing my cost per mile and my cost per piece. 

My cost per mile table is below: 

Any help on how to do this would be appreciated. I cannot seem to duplicate what I did in excel. Probably missing something simple. 

[v-shex-msft]

HI @JeffHm

Can you please share the dummy data with the expected result to help us clarify your data structure and test to coding formula on it? How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[JeffH]

Thank you, but I am still unclear on how to achieve my desired result. 

[Ashish_Mathur]

Hi,

If both your datasets have a Date column, then share the link from where i can download your PBI file.

[Ashish_Mathur]

Hi,

To make the solution easy, there must be a Date column in both datasets.