Forum Discussion

sbenzaquen's avatar
sbenzaquen
Helper I
5 years ago
Solved

Calculate billable amount by row

Hi, I'd like to estimate the billable amount/cost for each entry/row so I can sum them by end of the month. I would like to have an additional column/dax measure that multiplies the hours of the sam...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi sbenzaquen ,

     

    According to the data source file you gave, I created the relationship between the tables.

    billable amount = 
SWITCH (
    MAX ( 'Harvest report - Sample Data'[Subrole] ),
    "Junior",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate STR-Jr] ),
    "Senior",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate STR-Sr] ),
    "NA",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate CI] )
)

     

    You can check details from the attachment.

     

     

    Best Regards,

    Stephen Tao

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi sbenzaquen ,

 

According to the data source file you gave, I created the relationship between the tables.

billable amount = 
SWITCH (
    MAX ( 'Harvest report - Sample Data'[Subrole] ),
    "Junior",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate STR-Jr] ),
    "Senior",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate STR-Sr] ),
    "NA",
        MAX ( 'Harvest report - Sample Data'[Hours] )
            * MAX ( 'Contract Pricing'[Daily Rate CI] )
)

 

You can check details from the attachment.

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.