Forum Discussion

Applicable88's avatar
Applicable88
Impactful Individual
4 years ago

Getting Duration between two datetimes distributed correctly on time of occurence

Hello, I want to ask how I can calculate the duration correctly on the time of occurence. For example I have sample data in the screentshot. Its about a machine which is constantly fetching boxes an...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
Syndicate_Admin's avatar
Syndicate_Admin
Administrator
4 years ago

There are @Applicable88 ,

According to your description, try the following MEASURE formula:

work = 
IF (
    DAY ( MAX ( 'Order'[FinishTime] ) ) = DAY ( MAX ( 'Order'[StartTime] ) ),
    ( HOUR ( MAX ( 'Order'[FinishTime] ) ) - HOUR ( MAX ( 'Order'[StartTime] ) ) ) / 24,
    ( 24 - HOUR ( MAX ( 'Order'[StartTime] ) ) ) / 24
)

vhenrykmstf_0-1633500336295.png

If comprehension is disabled, further describe your requirements and provide screenshots of the desired results. I will answer your questions as soon as possible.

We look forward to your response.


Saludos
Henrio


If this post helps,then consider Accepting it as the solution to help other members find it more quickly.