Accounting for first and second data point per day by employee name

Like (0) Share

Report

Posted on 8 May 2024 12:59:54 by Em27

I have a power automate capture data from my email and add it to an excel database. Once in Excel I have a Power query add additional detail which I then build a Power BI report out of. Something I've been struggling with is separating my occurrences per day by employee.

I've tried indexing, and grouping but lose visibility or it errors out on me. I feel like I might be just to close to the problem and not seeing a better solution. Hoping someone could help me find some direction.

Example of what I want it to do.

Add Custom Column

add 1st or 2nd (or just 0 and 1, 2, 3, etc...) per agent for each day.

Agent 1, Wrap up, 2 minutes, 5/7/24, 1 occurrence

Agent 1, wrap up, 1.5 minutes, 5/7/24, 2 occurrence

Agent 2, Wrap up, 1 minutes, 5/7/24, 1 occurrence

Agent 1, wrap up, 2.5 minutes, 5/7/24, 3 occurrence

Agent 3, wrap up, 2.3 minutes, 5/7/24, 1 occurrence

Agent 1, wrap up, 1.5 minutes, 5/8/24, 1 occurrence