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.
1. To find Duplicate rows in a table based on a condition.
2. In the above image, i need to get duplicate rows based on Periods, Student ID & Date columns(if same set (i.e.,) periods,student id & date repeated,need to find that).
@kalikumarPlease Shre your ENDOUTPUT in table for more understanding.THANK YOU!!
Hi Mahesh,
This is the output I need,
1M-E101-Feb 28,2023 - Duplicate Rows present for this set
Thanks.
@kalikumar
Go to power query >> Duplicate Current Table >> Remove Unique Column >> Than Home >> Keep Row >> Keep Duplicates.
@kalikumar i hope this helps you!!THANK YOU!!
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 |
---|---|
96 | |
93 | |
82 | |
70 | |
64 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |