Recreating PowerBI formula for finding duplicates

[Dbjerring]

Hi Community,

I need help converting af PowerBI DAX function for finding duplicates.

I have a dataset based on logging, and often multiple duplicates are present.

We log time, number of lines and need these to be the foundation for a 'IsDuplicate' field with a TRUE/FALSE value.

Thank you in advance - your help is much appreciated!

My PowerBI function:

IsDuplicate =
IF (
COUNTROWS (
FILTER (
Logs;
Logs[LogCNumber] = EARLIER ( Logs[LogCNumber] )
&& Logs[LogTime.1] = EARLIER ( Logs[LogTime.1] )
&& Logs[LogID] < EARLIER ( Logs[LogID] )
)
)
> 0;
TRUE ();
FALSE ()
)

[JoshKushner · Accepted solution]

This sounds like a situation to use the Unique Tool.

Flow:

Input:

Unique Results:

Duplicate Results:

Unique Tool: