cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kattlees Member
Member

Only Show Duplicates

If I have this data - how do I get a table that will only SHOW Duplicates

 

Guest ID      Guest                   Start Date             End Date          MRNumber

123456       Sue Smith             2/1/18                     2/3/18            887799

5423160       Sue Smith            2/5/18                     2/5/18            887799

654321        Jill Jones              3/8/18                     3/12/18          998877

759845        Bill Bradly             2/8/18                    2/8/18             665577

 

I would only want the two Sue Smith rows to show up. Possiblity there could be 3 or 4 entries for the same person so would need all of them to show up.

1 ACCEPTED SOLUTION

Accepted Solutions
Vvelarde Super Contributor
Super Contributor

Re: Only Show Duplicates

@kattlees

 

Hi, you can use this calculated column to Mark the duplicates.

 

Duplicate =
IF (
    COUNTROWS ( FILTER ( Table1; Table1[GUEST] = EARLIER ( Table1[GUEST] ) ) )
        > 1;
    "YES";
    "NO"
)

The next Step will be apply a filter in the visual.

 

Regards

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

2 REPLIES 2
Vvelarde Super Contributor
Super Contributor

Re: Only Show Duplicates

@kattlees

 

Hi, you can use this calculated column to Mark the duplicates.

 

Duplicate =
IF (
    COUNTROWS ( FILTER ( Table1; Table1[GUEST] = EARLIER ( Table1[GUEST] ) ) )
        > 1;
    "YES";
    "NO"
)

The next Step will be apply a filter in the visual.

 

Regards

Victor




Lima - Peru
Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!




View solution in original post

Highlighted
gidster99 Frequent Visitor
Frequent Visitor

Re: Only Show Duplicates

Note: This only worked for me when I used commas and not semi-colons.

Thanks

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 275 members 2,688 guests
Please welcome our newest community members: