Finding Customers First Purchase

Quick question, I have three columns user_id, purchase_date, and product_name. I am trying to return the product name for the first purchase of each customer. How would I go about doing this?

Hey Zachary!

To do this, the first step would be to group by your user_id at your first level. Then you can make a new column on your first level and use this formula:

If(Min([purchase_date]) = [purchase date],[product_name])