Forum Discussion

Dominik82's avatar
Dominik82
Frequent Visitor
2 years ago
Solved

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...
  • Ahmedx's avatar
    2 years ago

    pls try this

  • Anonymous's avatar
    Anonymous
    2 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.