Forum Discussion
How do I remove duplicates on a more permanent basis?
I have a data set that looks like the below data. I created a graph based on the Time column. I want the graph to only count rows with the same ID once. The data set and subsequently the graph will be occassionaly updated. Please help.
ID Owner End Title Time
7 Ted White XD 9:45 1/1/18
7 Ted Green GT 9:45 1/1/18
8 John Blue PT 9:25 8/8/16
9 Bill Hazel TY 11:45 2/6/22
Use the DISTINCTCOUNT(TableName[ID]) Function. It will return 3 in the example above.
You can use the Table.Distinct function in Power query (remove duplicates) on the ID row, but it will delete the 2nd row there, which is likely not what you want unless you are ok to use the info for Ted/Green/GT.
1 Reply
Use the DISTINCTCOUNT(TableName[ID]) Function. It will return 3 in the example above.
You can use the Table.Distinct function in Power query (remove duplicates) on the ID row, but it will delete the 2nd row there, which is likely not what you want unless you are ok to use the info for Ted/Green/GT.