Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

Find the last account manager

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?

IDDate Account ManagerLast Account Manager
AA011/02/2022KimberlyTada 
AA012/03/2022KimberlyTada 
AA013/05/2022KimberlyTada 
AA014/06/2022TadaTada 
AB011/02/2022TimTim
AC011/02/2022WillWill
AC012/03/2022Jada Will
AC013/05/2022WillWill
1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hello,

 

Please try this code

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hello,

 

Please try this code

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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.