Time Difference based by workstep wise

[Varan_15]

Hi All,

I have data which is contains workstep (input, process, rejected, completed) i want to calculate the time differences between
(first input entry time - last completed exit time )

Example: same i have to get for each ID - highlighted expected result as below

Thanks,

Varan

[Jihwan_Kim]

Hi,

I am not sure how your data model looks like, but please check the below picture and the attached pbix file.

It is for creating a measure.

total minutes took measure: =
VAR _entrymin =
    MIN ( Data[Entry time] )
VAR _exitmax =
    MAX ( Data[Exit time] )
RETURN
    IF ( HASONEVALUE ( Data[ID] ), DATEDIFF ( _entrymin, _exitmax, MINUTE ) )

[Varan_15]

Hi @Jihwan_Kim ,

I need to create calculated column if use above mentioned dax it's taking entire data in min/ max values but i need only workstep  input - min entry date - completed max exit date

Thanks

[Jihwan_Kim]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Total minutes took CC =
VAR _inputentrymin =
    MINX (
        FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) && Data[Workstep] = "Input" ),
        Data[Entry time]
    )
VAR _completeexitmax =
    MAXX (
        FILTER ( Data, Data[ID] = EARLIER ( Data[ID] ) && Data[Workstep] = "Completed" ),
        Data[Exit time]
    )
RETURN
    IF (
        Data[Workstep] = "Completed",
        DATEDIFF ( _inputentrymin, _completeexitmax, MINUTE )
    )

[lin_k]

Hi @Varan_15 

in this case you can follow the lined out steps:

1. Select Datatype as Date & Time (you can do this by right-clicking on the header of the column)

2. Add a custom row where you subtract Entry from Extract time, simply do this by using "-" and writing a formular

3. Format the result of your custom column as you need it 

Let me know if this helps 🙂