Populate column for all rows that meet condition in one row

[ropathak]

New to DAX. Whenever UserType='New', I need to flag all rows for that userID that have a Timestamp within 10 hours of the original Timestamp when the User was 'New'. If the Timestamp goes beyond 10 hours from the last TS the user was still new, flag those rows as "Returning". 

UserID	Timestamp	UserType	UserIdentity (DESIRED COLUMN)
A	2019-03-02 03:20:00	New	New
A	2019-03-02 05:20:15	Returning	New
A	2019-03-015 05:24:09	Returning	Returning
B	2020-01-13 09:34:09	New	New
B	2020-04-01 12:09:34	New	New

[camargos88]

Hi @ropathak ,

Try this code:

Column =

VAR _userID = 'Table (2)'[UserID]

VAR _min = CALCULATE(MIN('Table (2)'[Timestamp]); FILTER(ALL('Table (2)'); 'Table (2)'[UserID] = _userID && 'Table (2)'[UserType] = "New"))

VAR _date = 'Table (2)'[Timestamp]

RETURN IF(DATEDIFF(_min; _date; HOUR) <= 10; "New";

IF(DATEDIFF(CALCULATE(MAX('Table (2)'[Timestamp]); FILTER(ALL('Table (2)'); 'Table (2)'[UserID] = _userID && 'Table (2)'[UserType] = "New")); 'Table (2)'[Timestamp]; HOUR) > 10; "Returning"; "New"))

Ricardo