Find first date where a cumulative total condition is met
I'm struggling with a measure and would appreciate if anyone could help!
Here's what I'm trying to do:
I have a physical table of sales amount by employee by date like this:
Name | Amount | Date
John | 500 | 10/04/21 Amanda | 700 | 12/04/21 John | 400 | 15/04/21
I want to create a measure (no custom column allowed since I'm using a shared dataset) where, for each employee, I'll get the first date where they achieved cumulative 600 or more in sales. For Amanda, the result would be 12/04/21. For John, the result would be 15/04/21.
I tried creating a virtual table using SUMMARIZE with the cumulative sum and getting the first date in this table but it doesn't work.