Forum Discussion
Filtering Away Certain Duplicate Values in Pivot Data Source
Changed the Name 1 to Name01
Sorted the dataset by Name and No. of Initial Moderation Tasks
created filter columns rank, count, subnum, ref
did a power query on dataset including filter columns
created 2 reference queries Top 2 and Bottoms queries
filtered out bottoms on Top 2 reference query
filtered out Top2 on Bottoms reference query
cheers
on the screen shot below how can anyone tell which ones the duplicates are for that employee:
- If I were to make a wild guess on the screenshot image
I would pick row 2 and row 160 to be the actual shifts, the rest are overlaps.
What are your thoughts on my guess?- Employee 1 is on mid shift. So he appears on both morning and night shift overlaps which I want to exclude him from. I don't know how to write the formula but the logic comes to my mind is that take the max of these values, including only max ignore rest.
Changed the Name 1 to Name01
Sorted the dataset by Name and No. of Initial Moderation Tasks
created filter columns rank, count, subnum, ref
did a power query on dataset including filter columns
created 2 reference queries Top 2 and Bottoms queries
filtered out bottoms on Top 2 reference query
filtered out Top2 on Bottoms reference query
cheers