Find the last account manager

[Anonymous]

Hi All,

I would like to find the last/current account manager within the sample data. Each account has a unique Id but the account managers change from time to time. I would like to track the most current/last manager for each date and ID. My desired output is the Last account Manager column filled down for each ID and Date.

Please help how to go about this?

ID	Date	Account Manager	Last Account Manager
AA01	1/02/2022	Kimberly	Tada
AA01	2/03/2022	Kimberly	Tada
AA01	3/05/2022	Kimberly	Tada
AA01	4/06/2022	Tada	Tada
AB01	1/02/2022	Tim	Tim
AC01	1/02/2022	Will	Will
AC01	2/03/2022	Jada	Will
AC01	3/05/2022	Will	Will

[Anonymous · Accepted solution]

Hello,

Please try this code

last Mananger = calculate(max(Feuil2[Account Manager]),Feuil2[Date ]=max(Feuil2[Date ]),allexcept(Feuil2,Feuil2[ID]))