Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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,
Please check if the measures in the PBIX file below return your expected result.
https://1drv.ms/u/s!AhsotbnGu1NolBKEi3WplK4FX9Rl
Regards,
Lydia
Worked like a charm!
I had to a little fiddling to get it to work with my actual data, but this worked perfectly.
Thanks!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |