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 ()
)
Solved! Go to Solution.
This sounds like a situation to use the Unique Tool.
Flow:
Input:
Unique Results:
Duplicate Results:
Unique Tool: