Need Calculated column for IF one EmpId has one value then NEW else Old

[Venkateswara_ra]

Hi All,

My condition here if one Emp Id have one Login Id then its New if the same EmpId have two LoginId then Old need to show in separate column

Need Calculated column for this condition any help 

My Data Is like dis 

EmpId	LoginID	Staff Id	Calculation Column
1	768241	109099588	NEW
1	768241	109099589	NEW
3	458996	89447383	NEW
3	458996	89447384	NEW
7	1038397	138326615	OLD
7	1038397	138326616	OLD
7	767451	109023218	OLD
7	767451	109023219	OLD
7	981640	130411211	OLD
7	767451	129916202	OLD
4	475441	90549143	New
4	475441	89919587	New
4	475441	89919588	New
5	461831	89599513	New
5	461831	89599514	New

[amitchandak]

@Venkateswara_ra , Create a new column as

if(countx(filter(Table,[Staff Id] =earlier([Staff Id])),[LoginID])+0=1, "New","Old")

[ryan_mayu · Accepted solution]

@Venkateswara_ra 

please try this

Column = if(CALCULATE(DISTINCTCOUNT('Table'[LoginID]),ALLEXCEPT('Table','Table'[EmpId ]))=1,"new","old")