Power Platform Community Forum Thread Details

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

Categories:

Power Query