Status & Workflow Processing Time

Hi lukeydb_ 

Maybe you can try these method:

I used your data to try:

Then created a measure:

Date_sum =
VAR _Workflow = SELECTEDVALUE('Table (2)'[Workflow])
// Get the current workflow
VAR _FIl = FILTER(
            ALLSELECTED('Table (2)'),
            'Table (2)'[Workflow]=_Workflow
            )
// Filter by Workflow
VAR _maxDate = CALCULATE(
                    MAX('Table (2)'[Workflow Change Step]),
                    _FIl
                    )
VAR _minDate = CALCULATE(
                    MIN('Table (2)'[Workflow Change Step]),
                    _FIl
                    )
// Get the date maximum and minimum values for each workflow
RETURN DATEDIFF(_minDate,_maxDate,DAY)

DIFF_WORKFLOW =
VAR _Workflow = SELECTEDVALUE('Table (2)'[Workflow])
VAR _status = MID(MAX('Table (2)'[Status]),6,2)
//get the current status number
VAR _currentdate = MAX('Table (2)'[Workflow Change Step])
//get the current Workflow Change Step
VAR _Perviousdate = CALCULATE(
                        MAX('Table (2)'[Workflow Change Step]),
                            FILTER(
                                ALLSELECTED('Table (2)'),
                                MID('Table (2)'[Status],6,2)<_status
                                &&
                                'Table (2)'[Workflow]=_Workflow
                                )
                            )
//get the last date value
RETURN IF(
        ISBLANK(_Perviousdate)=FALSE(),
        DATEDIFF(_Perviousdate,_currentdate,DAY)
        )

click the show Items with no data

The result is as follow:

Best Regards,

Zhengdong Xu

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