Forum Discussion
Solved
Populate user rows with store name from first purchase
Hi experts. Problem: Trying to create calculated column that looks up which store user used in their first purchase and populate column with that data. Wanted outcome: USER_ID PURCHASE...
MikaelB , Create a new column like
New column =
var _max = Minx(filter(Table, [USER_ID] = earlier([USER_ID])),[PURCHASE_DATE])
return
[Value] -maxx(filter(Table, [PURCHASE_DATE] = _max && [USER_ID] = earlier([USER_ID])),[STORE_NAME])
amitchandak
Super User
Super UserMikaelB , Create a new column like
New column =
var _max = Minx(filter(Table, [USER_ID] = earlier([USER_ID])),[PURCHASE_DATE])
return
[Value] -maxx(filter(Table, [PURCHASE_DATE] = _max && [USER_ID] = earlier([USER_ID])),[STORE_NAME])
This worked. Thank you for the solution. Danced around this the whole day 🙂