topic Re: Count individual event in the table in DAX Commands and Tips

Count individual event in the table

Sansarmurun — Wed, 13 Jan 2021 02:19:20 GMT

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].

Re: Count individual event in the table

lbendlin — Tue, 19 Jan 2021 00:04:53 GMT

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

Re: Count individual event in the table

Sansarmurun — Tue, 19 Jan 2021 07:33:41 GMT

Hi lbendlin

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

Re: Count individual event in the table

Anonymous — Tue, 19 Jan 2021 08:58:08 GMT

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