How to Calculate % Billable and Non-Billable in Report

[jkniffen]

Hi,

I am very new to Power BI and will most likely have some future silly questions.  🙂  My first question, there is a canned Project Labor report available in our Power BI.  I have three columns for a table  (Billable Hours, Do Not Bill Hours, and Hours Actual).  All I need to do is calculate what the percent is of billable and non-billable hours for the Hours Actual and show them in two additional columns.  Is it possible to do this?  Thank you very much for your help.

Joe

[Anonymous · Accepted solution]

Hi @jkniffen ,

Sample data:

Percent of billable hours for the hours actual = var _billable=SUM('Table'[Billable Hours])
var _actual=SUM('Table'[Hours Actual])
return DIVIDE(_billable,_actual)

Percent of notbill hours for the hours actual = var _notbill=SUM('Table'[Do Not Bill Hours])
var _actual=SUM('Table'[Hours Actual])
return DIVIDE(_notbill,_actual)

Click "%" in the measure tool to display the percentage.

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.           

[jkniffen]

Thank you for your help Stephen!   🙂