topic Re: create column using dax value repeats in DAX Commands and Tips

create column using dax value repeats

Edinson_33 — Mon, 14 Aug 2023 22:02:32 GMT

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

Re: create column using dax value repeats

tamerj1 — Tue, 15 Aug 2023 05:46:11 GMT

Hi Edinson_33

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

Re: create column using dax value repeats

Edinson_33 — Tue, 15 Aug 2023 19:14:08 GMT

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

Periodo

Re: create column using dax value repeats

tamerj1 — Tue, 15 Aug 2023 20:10:44 GMT

Edinson_33

Please try

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