Forum Discussion
Solved
Remove duplicates based on values from multiple cells
Hi Community, We have dataset based on logs - here we would like to create a new column with a true/false value if the line is a duplicate. We have UserID, LogTimeDate, LogTime, and number of lo...
You could modify the formula as shown below.
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 () )
You could modify the formula as shown below.
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 ()
)
v-chuncz-msft: I get a "Too many arguments were passed to the IF function. The maximum argument count for the function is 3.":
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 ();
)Any thoughts?
Thank you so much for the help
//David