Count individual event in the table

[Sansarmurun]

Hello PBI Gurus,

I need your help on integrating duplicated events in the table below. Another reason the system generated duplicated events is every morning 7AM continuing event splitted in this moments. Otherwise event register mannually created duplicated item somrtimes. 

Here are the criterias in order to integrate sub events:

1. Events same as [Unit]

2. Events same as [TimeComponent]

3. Events same as [TCodeDesc]

4. And gap between sub events created duration must be less than 15 minutes between 1st event [DateTimeEnd] & 2nd event [DateTimeStart].

[lbendlin]

Please provide sample data in usable format and show the expected outcome.

[Sansarmurun]

Hi lbendlin

How can I attach any .csv, xls, xlsx in here?

[Anonymous]

Hello @Sansarmurun 
You can attach the file using one drive, dropbox, drive.