Calculating Remaining Hours from Multiple Time Entries on Individual Tickets

[Lazlo_Gonzo]

We have a KACE K1000 that uses a MYSQL DB to house all of our ticket data.

From the below table I would like to make a new table/report that for each "HD_TICKET_ID" want to add up the total of each associated "Total Hours Worked" row and subtract that sum from the "Hours Purchased" Column and have the result in a new column, "Hours Remaining".

I'm sorry, I'm not a DBA, or really a PowerBI guy. Please let me know any other info I can provide that will assist.

[Anonymous · Accepted solution]

@Lazlo_Gonzo,

Please check if the measures in the PBIX file below return your expected result.

https://1drv.ms/u/s!AhsotbnGu1NolBKEi3WplK4FX9Rl

Regards,
Lydia

[Lazlo_Gonzo]

Worked like a charm!

I had to a little fiddling to get it to work with my actual data, but this worked perfectly.

Thanks!