Ignore certain values after a specific date

[Anonymous]

Best way I can expalin what I need: 

I have a list of 100 people who work in my team who all create entries on a database

I am trying to pull volume of data entries over time for my team but some of these people have moved to other teams and still create data entries in the same database.

I only want to see volumes for what they did while in my team. 

How can I ignore some of the people but only after a certain date?  

Thanks, Dan

[amitchandak]

@Anonymous ,Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

refer to my HR blog if that can help - if you have start and end date

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

HR Blog -https://www.youtube.com/watch?v=e6Y-l_JtCq4

[Anonymous]

Above is the colleague data 

I'll want to do several counts over many tables so if you are able to provide the methodology for how to filter based on; ignoring anything after 'EXIT DATE' for each person? Some people won't have an exit date because they are current colleagues.

[Anonymous]

Sorry I only really care about filtering after the exit date if reason for leaving was 'Internal Promotion'. If the reason was not 'Internal Promotion' then there wont be any data to filter for them after the exit date anyway

[v-jingzhang]

Hi @Anonymous 

Is there any column like User Id in the table? It is to be used in the filter but I don't see it in your screenshot. And I guess there is another table like Fact table or EntryRecord table which people create entries in. What is this table like? What is the relationship between it and Colleague table? Per my understanding, Fact table needs to be filtered not the Colleague table. Could you provide some more info about Fact table after removing the sensitive information. This will be helpful. Thanks very much.

Best Regards,
Community Support Team _ Jing Zhang