Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Hi @ropathak ,
Try this code:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
49 | |
25 | |
20 | |
15 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |