It would be great if you could provide more clarity on the logic for calculating a repair.
As of now, I have taken the following assumption:
Repair duration = Time difference in minutes between "Created On" and "Completed On"
Thus, I created a calculated column in the table as follows, that calculates the repair duration in Minutes:
Duration = DATEDIFF(Repairs[Created on],Repairs[Completed On],MINUTE)I have then used the "Duration" measure to calculate number of repairs in a minute and then on a hour. Here is the measure:
Repairs per Hour =
VAR _repairPerMinute = DIVIDE(COUNT(Repairs[Work Order]),SUM(Repairs[Duration]))
VAR _repairPerHour = _repairPerMinute * 60
RETURN
ROUND(_repairPerHour, 0)If my assumption is correct then you can use this measure and it should solve your problem. Here is screenshot of the result:
In case, this is not something that you expect, kindly provide the following details:
- A logic for the repair duration calculation
- A sample anonymized dataset
- A sample image/data of the expected answer
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
It would be great if you could provide more clarity on the logic for calculating a repair.
As of now, I have taken the following assumption:
Repair duration = Time difference in minutes between "Created On" and "Completed On"
Thus, I created a calculated column in the table as follows, that calculates the repair duration in Minutes:
Duration = DATEDIFF(Repairs[Created on],Repairs[Completed On],MINUTE)I have then used the "Duration" measure to calculate number of repairs in a minute and then on a hour. Here is the measure:
Repairs per Hour =
VAR _repairPerMinute = DIVIDE(COUNT(Repairs[Work Order]),SUM(Repairs[Duration]))
VAR _repairPerHour = _repairPerMinute * 60
RETURN
ROUND(_repairPerHour, 0)If my assumption is correct then you can use this measure and it should solve your problem. Here is screenshot of the result:
In case, this is not something that you expect, kindly provide the following details:
- A logic for the repair duration calculation
- A sample anonymized dataset
- A sample image/data of the expected answer
Best Regards,
Udit
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudo 👍
🚀 Let's Connect: LinkedIn || YouTube || Medium || GitHub
✨ Visit My Linktree: LinkTree
Helpful resources
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Fabric Community Update - January 2025
Find out what's new and trending in the Fabric community.
