Forum Discussion

Varan_15's avatar
Varan_15
Helper III
3 years ago

Time Difference based by workstep wise

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 )   Exa...
Need Help
Varan_15's avatar
Varan_15
Helper III
3 years ago

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's avatar
Jihwan_Kim
Super User
3 years ago

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 )
    )