Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
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
Doesn't the semi-colon vs comma issue have to do with the language setup of your computer?
@Vvelarde Thanks for the solution. I was looking for this solution and it helps me. 😊
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
Solution DOES NOT WORK> can't use semi-colons. Only Commas. Also, get an error on the
EARLIER ( Table1[GUEST] )
Piece.
Maybe ease up on the intensity/outrage of your reply a bit? I'd really hate to see people being discouraged from participating due to getting yelled at if they make a mistake.
Note: This only worked for me when I used commas and not semi-colons.
Thanks
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |