Hi,
I'm trying to figure out how to have a calculated column flag just the first time (by date) and last time a user logs in. The problem I'm running into is that a user can log in 2 or more times on that first day they log in. I don't really care which of those lines gets flagged with a "1" but I need just one.
Same thing for the last day they have logged in. I then use these flags (with another calculated column) to determine the time between their last login and second to last login, and so on.
This is what I have so far (but if flags ALL login rows on that first day)
=IF(calculate(min(Table1[Date]),All(Table1),Table1[Name]=EARLIER(Table1[Name]))=[date],1,0)
I'm trying to figure out how to have a calculated column flag just the first time (by date) and last time a user logs in. The problem I'm running into is that a user can log in 2 or more times on that first day they log in. I don't really care which of those lines gets flagged with a "1" but I need just one.
Same thing for the last day they have logged in. I then use these flags (with another calculated column) to determine the time between their last login and second to last login, and so on.
This is what I have so far (but if flags ALL login rows on that first day)
=IF(calculate(min(Table1[Date]),All(Table1),Table1[Name]=EARLIER(Table1[Name]))=[date],1,0)
