Tying to alternate row with call time and name

[modxplus]

I have been dealing with this problem most of today and havent been able to figure it out. 

I put a mock up below of what my data looks like. Columns A - C are pulled from SQL into Power BI and Column D is pulled from a merge from another table in Power Query. (there are about 15k rows)

You can see in Row C some of the Colors are blank. 

But looking at row 5 for example the conversation start/end times are bewteen the start and end times for John on line 3. 

Same with Bryan on on line 12 and 14. Both those conversation start and end times are bewteen the start and end time of Bryan on line 7.

So you can see my EXPECTED column in E. How are the colors are filled in with what is in the "master" call

Its a lot but basically I need to look at the nulls > check for other calls that are within the same time frame > make sure its by the same person > populate the original color onto a new line.

Thanks for your help!

[mahoneypat]

Please provide your sample data in a copy/paste-able format (insert table or provide a link to data on Google Drive, etc.). That will make it easier for people to provide a more specific solution.

One thing you could try is to group on the Name column and don't aggregate (keep all rows). You can then do a fill down on the nested tables, and then re-expand them. In your sample data, it looks like it is always the previous non-null value for that person. Is that the case?

Pat

[modxplus]

That is what I did in the meantime to be able to get my report working. 

Just sort by Name, then Conversation Start time and fill down. It was about 95% correct following that approach. Still would prefer to look by time. 

[mahoneypat]

Do you plan to provide a link to sample data that includes an example of the 5% that isn't working?

Pat