FOR loop to update Variable?

[th3h0bb5]

I'm in charge of making sure all employeed receive 8 hours (480 minutes) of training every 60 days. As soon as they hit that mark, their 60 day clock starts over (yes, I know that's dumb).  My data is three columns: Employee, Date Trained, Total Minutes.

As an example, if Bob gets 8 hours of training on 12/10/2019, he must get another 8 hours before 2/8/2020 (60 days later). If Bob gets in another 8 hours four days later (12/14), the 60 days clock resets and now he must get 8 hours in before 2/12.

How can I do this in DAX?

Here's my data:

Employee	Date Trained	Total Minutes
Bob	11/6/2019	113
Bob	11/7/2019	375
Bob	11/14/2019	191
Sarah	9/30/2019	730
Sarah	10/2/2019	50

Using Bob as an example, I think I need to:

1. Create a Variable for StartDate
   1. StartDate = MIN(Date Trained)  --11/6/2019
2. Create a Variable that is DueDate
   1. DueDate = DATEADD (StartDate,  60, DAYS)  --1/5/2019
3. Row-by-row for a given employee, SUM the minutes worked since StartDate
4. If that SUM goes above 480 for a given employee, update the DueDate variable to the Date Trained plus 60 days

[v-easonf-msft]

Hi , @th3h0bb5 

I'm a little confused by your description.

Please kindly share your sample data and expected result  if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

Best Regards,
Community Support Team _ Eason

[th3h0bb5]

Here is a link to some sample data. The 'DueDate' column is the desired outcome. 

The 'Due Date' value begins at 60 days from the earliest 'Date Worked' for a given employee. Once the SUM of 'Total MIN' passes 8 hours, that DueDate gets updated.