The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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:
User | Count |
---|---|
28 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
34 | |
15 | |
12 | |
7 | |
6 |