Forum Discussion
Solved
Latest Sales rep for each customer
Hello my friends i am struggling to get correct DAX for Latest Sales Rep for each customer id.
My table is as below
| Customer # | Sales Representative Name | Entry Date |
| 3 | A | 17/04/2019 |
| 3 | B | 29/06/2021 |
| 1121 | AA | 14/02/2016 |
| 1121 | BB | 15/02/2016 |
| 1 | AAA | 5/10/2023 |
| 1 | BBB | 2/10/2023 |
| 1199 | AAAA | 16/10/2023 |
| 1199 | BBBB | 18/10/2023 |
Result should be
| Customer # | Sales Representative Name | Entry Date |
| 3 | B | 29/06/2021 |
| 1121 | BB | 15/02/2016 |
| 1 | AAA | 5/10/2023 |
| 1199 | BBBB | 18/10/2023 |
2 Replies
- Ahmedx
Super User
Thank for your help it is excetly i was looking for
