Return value from a column based on date in another column

Hi andronachealin ,

You need to put the AlB 's M query in Advanced Editor.

Or you can use merge function to get the result.

1. Copy the original table, then group by users to get the min date.

2. And we can merge two tables based on two conditions.

3. We can expand it to get the min date course.

4. At last we need to merge again to get the result.

If you have any question, please kindly ask here and we will try to resolve it.

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.