Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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 |
Solved! Go to Solution.
Hello,
Please try this code
Hello,
Please try this code
User | Count |
---|---|
21 | |
20 | |
15 | |
10 | |
7 |
User | Count |
---|---|
28 | |
28 | |
12 | |
12 | |
12 |