How to get the max closed date for the previous tasks in a wo

[Navneet_Kaur]

Sample data . Last column is the desired output. Looking to get the Max closed_date for previous tasks in the same wo.

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

It is for creating a new column.

Expected result CC =
MAXX (
    FILTER (
        'Table',
        'Table'[wo] = EARLIER ( 'Table'[wo] )
            && 'Table'[Task_No] < EARLIER ( 'Table'[Task_No] )
    ),
    'Table'[closed_date]
)

[Navneet_Kaur]

Thanks a bunch. It worked.

[Navneet_Kaur]

Thanks. Let me check it out