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
Go to Solution.
please try this
Column = if(CALCULATE(DISTINCTCOUNT('Table'[LoginID]),ALLEXCEPT('Table','Table'[EmpId ]))=1,"new","old")
Proud to be a Super User!
View solution in original post
@Venkateswara_ra , Create a new column as
if(countx(filter(Table,[Staff Id] =earlier([Staff Id])),[LoginID])+0=1, "New","Old")
Check out the on demand sessions that are available now!
Check out the Winners!
Features releasing from October 2020 through March 2021