Power BI - Team Name List dependent on Date Filter

[ShaneHi]

Hi,

I'm looking for some advice/help on how to have a Team Name list to change depending on what Date Range is selected. 

I'm not the best with Power BI - i'm slowly learning but would appreciate any help in very basic terms!

The problem:

I have a Team Index table which lists a number of colleagues and their associated Team Name. Recently we have had some moves where colleagues have moved into a new team from a certain date. The first group of Colleagues moved across to a new team from 8th Feb and the second group moved over on 14th Feb.

The issue I have is I only want their data to be included on the new team from the date they joined that team, and I still need their historic data to be recorded under the old team name. And it's all dependent on what date has been selected in a filter.

I'm just lost how to do this. The only way I was thinking was to have a measure use some sort of IF statement like IF the selected date is less than 8th Feb, it uses a team name list from Column C, If the selected date is between 8th & 14th Feb, it uses a team name list from Column D, Otherwise if the selected date is after the 14th Feb, it uses a team name list from Column E.

Is this possible and how the hell would I code it? Or otherwise I'm open to other suggestions!

Thank you so much in advance

[ShaneHi]

Unfortunately I can't share the file due to security restrictions

Essentially, the Team Index table will look something like the below.

Colleague	Team	New Team Date	Team (Original)	Team (8th Feb)	Team (14th Feb)
Colleague A	Team A		Team A	Team A	Team A
Colleague B	Team B	08/02/2024	Team B	Team A	Team A
Colleague C	Team C	14/02/2024	Team C	Team C	Team A
Colleague D	Team C	14/02/2024	Team C	Team C	Team A
Colleague E	Team B	08/02/2024	Team B	Team A	Team A

[nareshr89]

Can you share the sample data/pbix file of the above issue to check further.