Creating a calculated column that brings the first value that appears according to other lines

[hugo_barbara]

Guys,
All good?

Is there a way to create a calculated column that brings the first time such a condition appears in another column.

For example, I have a table that shows the week by week evolution of a project, I would need to get the first time we reached 100%.

follow the example

In the column appears a "YES" and the others remain blank?

[hugo_barbara]

Tksss!!!!!!!

[tamerj1 · Accepted solution]

Hi @hugo_barbara 

Please try

Flag =
IF (
MINX (
FILTER (
CALCULATETABLE ( 'Table', ALLEXCEPT ( 'Table', 'Table'[UNIDADE] ) ),
'Table'[Progresso] = 1
),
'Table'[DATA]
) = 'Table'[DATA],
"True"
)