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 ,

 

Sorry for my late reply.

It’s a bit cumbersome to manually input the picture data, please share me with your pbix file from your Onedrive for Business.

And what expected result do you want?

 

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.

sbenzaquen's avatar
sbenzaquen
Helper I
5 years ago

Hi Stephen,

 

Thanks for taking a look. 

 

See google drive link for the sample data: https://docs.google.com/spreadsheets/d/1Aiz-l2pB6nY7xftwnXSOw3xrjNsxN9Hh4NVohtB6hAk/edit?usp=sharing

 

The expected result is to have an additional column with the billable amount relating to each entry. The idea is to be able to aggregate the amount by project/end of month.

 

Let me know if there is anything else i can help with.

 

thanks,

Salvador

 

thank you,

salvador