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 ...
Need Help
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.