Filtering grouped data based on multiple row properties

[Jawwad_Adel]

Hi, I have a table that looks like the one below. I wish to filter for Employees that have had more than 1 job title. 

ID	Name	Position	Title	Date
1001	Allen P	4005	HR Manager	20210601
1001	Allen P	4005	HR Manager	20201201
1001	Allen P	4005	HR Manager	20200601
1003	Peter S	3470	Sales Manager	20210601
1003	Peter S	3460	Sales Associate	20201201
1003	Peter S	3460	Sales Associate	20200601
1006	Sam B	5030	Data Analyst	20210601
1006	Sam B	5030	Data Analyst	20201201
1006	Sam B	5030	Data Analyst	20200601

The output should look like this:

ID	Name	Position	Title	Date
1003	Peter S	3470	Sales Manager	20210601
1003	Peter S	3460	Sales Associate	20201201
1003	Peter S	3460	Sales Associate	20200601

Is there a way to do this? Any help will be appreciated 🙂 Thanks!

[atcodedog05 · Accepted solution]

Hi @Jawwad_Adel 

You can do something like this. 

1. Using summarize to get distinct position count for person.

2. Using join to add distinct postion back to data.

3. Filtering distinct position more than 1.

Hope this helps : )

[Jawwad_Adel]

Hey, that works perfectly! Thanks a lot! 🙂

[atcodedog05]

Happy to help : ) @Jawwad_Adel