Processing Status Based on Multiple Dates

Hi PBInewbie17 ,

I have created a simple sample, please refer to it to see if it helps you.

Create a measure.

Measure =
IF (
    MAX ( 'Table'[days in processing] ) > 30
        && MAX ( 'Table'[date completed] ) = BLANK (),
    "Overdue",
    IF (
        MAX ( 'Table'[days in processing] ) > 30
            && MAX ( 'Table'[date completed] ) <> BLANK (),
        "Missed deading",
        IF (
            MAX ( 'Table'[date completed] ) = BLANK ()
                && MAX ( 'Table'[days in processing] ) <= 30
                && MAX ( 'Table'[date due] ) >= TODAY (),
            "In progressing",
            IF (
                MAX ( 'Table'[days in processing] ) <= 30
                    && MAX ( 'Table'[decision ] ) <> BLANK ()
                    && MAX ( 'Table'[date completed] ) <> BLANK ()
                    && MAX ( 'Table'[date processing resumed] ) = BLANK (),
                "On time",
                "Incomplete"
            )
        )
    )
)

If I have misunderstood your meaning, please provide more details with your desired output.

Best Regards

Community Support Team _ Polly

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