topic How to get the max closed date for the previous tasks in a wo in DAX Commands and Tips

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

Navneet_Kaur — Wed, 23 Nov 2022 15:02:57 GMT

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

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

Jihwan_Kim — Wed, 23 Nov 2022 15:15:32 GMT

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

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

Navneet_Kaur — Wed, 23 Nov 2022 15:18:35 GMT

Thanks. Let me check it out

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

Navneet_Kaur — Wed, 23 Nov 2022 15:25:04 GMT

Thanks a bunch. It worked.