Get Higher custom Date from Subtasks

Questions & Answers
, ,
1

Hello guys!
i have epics with subtasks inside. I need get the “Fecha Fin de Analisis” custom field date with the highest value. This values belong to subtasks
In the example below i have the second column with the date values and a i need show in the third column at epic level the max value (Apr 18 2024)

image
image1000×363 15.1 KB

thanks for your help

2

I resolved using this calculate

Tail(
Order(
		 -- set of sub-tasks for the issue
         Filter(
    Descendants([Issue.Sub-task].CurrentMember,[Issue.Sub-task].[Sub-task]),
    Not IsEmpty([Issue.Sub-task].CurrentMember.Get('Fecha Fin de Análisis'))
    AND
    [Measures].[Issues with Fecha Fin de Análisis] > 0
  )
        , 
		 -- value for ordering
        [Issue.Sub-task].CurrentMember.Get('Fecha Fin de Análisis') ,
     -- symbol
        ASC
     )
 
 
).Item(0).Get('Fecha Fin de Análisis')
1 Like