Identify and highlight duplicate rows

Hello everyone, Whilst I see there are several posts regarding duplicate rows in a table, I can't find the solution to my particular query. I have 2 tables (TableA and TableB) containing data from ...

Need Help

Anonymous

2 years ago

Hi Anonymous ,

Please try to create a new table with below dax formula:

Table =
VAR tmp =
    UNION ( 'Table 1', 'Table 2' )
VAR tmp1 =
    GROUPBY (
        tmp,
        [Site ID],
        [PersonID],
        [WeekCommencing],
        [Monday],
        [Thursday],
        [Wednesday],
        [Friday],
        "Ctn", COUNTX ( CURRENTGROUP (), [CustomNote] )
    )
VAR tmp2 =
    FILTER ( tmp1, [Ctn] = 1 )
RETURN
    tmp2

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Identify and highlight duplicate rows.pbix78 KB

Table = VAR tmp = UNION ( 'Table 1', 'Table 2' ) VAR tmp1 = GROUPBY ( tmp, [Site ID], [PersonID], [WeekCommencing], [Monday], [Thursday], [Wednesday], [Friday], "Ctn", COUNTX ( CURRENTGROUP (), [CustomNote] ) ) VAR tmp2 = FILTER ( tmp1, [Ctn] = 1 ) RETURN tmp2

Forum Discussion

Identify and highlight duplicate rows

Related content

Identifying duplicates

Identifying Duplicates

Identify duplicates

Highlight duplicate values in a table

Identifying duplicates