create column using dax value repeats

[Edinson_33]

I have this table i need create a column with dax call "Pilo", but i have condicions for the value 1 o 0 , is the colunm (Id Año sem Beca) have the same value put 1 when see for frist time but is apper anotther value with the 4 columns equal put Zero. Like the next example.

Thx for help.

Id	Año	sem	Beca	Pilo
U00097435	2015	Sem 1	BI14 -	1
U00097435	2015	Sem 1	BI14 -	0
U00097435	2015	Sem 2	BI14 -	1
U00097435	2016	Sem 1	BI14 -	1
U00097435	2016	Sem 1	BI14 -	0
U00097435	2016	Sem 2	BI14 -	1
U00097435	2017	Sem 1	BI14 -	1
U00097435	2018	Sem 1	BI14 -	1
U00097435	2018	Sem 1	BI14 -	0

[Edinson_33]

Hello , the only adictional column i see  and is diferrent is

Periodo

15

45

75

15

45

75

15

45

97

[tamerj1]

@Edinson_33 

Please try

Pilo =
INT (
'Table'[Periodo]
= CALCULATE ( MIN ( 'Table'[Periodo] ), ALL ( 'Table'[Periodo] ) )
)

[tamerj1]

Hi @Edinson_33 

do you have other columns in the table like date or index or anything that distinguishes between the two duplicate rows?