Forum Discussion

JeffH's avatar
JeffH
Icon for Helper I rankHelper I
5 years ago

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

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. 

 

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    Hi,

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

  • JeffH's avatar
    JeffH
    Icon for Helper I rankHelper I
    5 years ago

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

    • Ashish_Mathur's avatar
      Ashish_Mathur
      Icon for Super User rankSuper User
      5 years ago

      Hi,

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