Forum Discussion
Dominik82
2 years agoFrequent Visitor
Identify duplicates across 2-x column combinations
Hello PowerBI Users currently I'm searching for a solution to mark double entries in a timetable->employee list. My table looks like this: StartTimeDate EndTimeDate Employee 01.01.2...
- 2 years ago
pls try this
- Anonymous2 years ago
Hi Dominik82 ,
Ahmedx ,good answer!
And you can also use EARILER in the DAX:
Use these DAX to create new columns:Start + Employee = IF( COUNTROWS( FILTER( 'Sheet23', 'Sheet23'[StartTimeDate] = EARLIER(Sheet23[StartTimeDate]) && 'Sheet23'[Employee] = EARLIER(Sheet23[Employee]) ) ) > 1, 1, BLANK() )Start + End + Employee = IF( COUNTROWS( FILTER( 'Sheet23', 'Sheet23'[StartTimeDate] = EARLIER(Sheet23[StartTimeDate]) && 'Sheet23'[EndTimeDate] = EARLIER(Sheet23[EndTimeDate]) && 'Sheet23'[Employee] = EARLIER(Sheet23[Employee]) ) ) > 1, 1, BLANK() )The final output is as below:
Best Regards,
Dino Tao
If these posts help, then please consider both of the answers to Accept it as the solution to help the other members find it more quickly.
Anonymous
2 years agoNot applicable
Hi Dominik82 ,
Ahmedx ,good answer!
And you can also use EARILER in the DAX:
Use these DAX to create new columns:
Start + Employee =
IF(
COUNTROWS(
FILTER(
'Sheet23',
'Sheet23'[StartTimeDate] = EARLIER(Sheet23[StartTimeDate]) &&
'Sheet23'[Employee] = EARLIER(Sheet23[Employee])
)
) > 1,
1,
BLANK()
)Start + End + Employee =
IF(
COUNTROWS(
FILTER(
'Sheet23',
'Sheet23'[StartTimeDate] = EARLIER(Sheet23[StartTimeDate]) &&
'Sheet23'[EndTimeDate] = EARLIER(Sheet23[EndTimeDate]) &&
'Sheet23'[Employee] = EARLIER(Sheet23[Employee])
)
) > 1,
1,
BLANK()
)
The final output is as below:
Best Regards,
Dino Tao
If these posts help, then please consider both of the answers to Accept it as the solution to help the other members find it more quickly.