FIND THE LATEST STATUS PER CLIENT

[Syndicate_Admin]

Good Day Experts

I request support to find the latest status per client.

CUSTOMER	DATE	STATE
A	01/01/2023	ACTIVE
A	13/05/2023	LOST
B	01/04/2023	NEW
C	13/05/2023	LOST
A	01/01/2023	NEW
C	01/01/2023	NEW
C	01/02/2023	ACTIVE
B	13/05/2023	ACTIVE

[Ritaf1983 · Accepted solution]

Hi @Syndicate_Admin 
You can use dax measure:
Last Status = VAR Ld = CALCULATE(MAX('Table'[DATE]), ALLEXCEPT('Table', 'Table'[CUSTOMER])) RETURN CALCULATE(MAX('Table'[STATE]), FILTER('Table', 'Table'[DATE] = Ld && 'Table'[CUSTOMER] = SELECTEDVALUE('Table'[CUSTOMER])))

Link to sample file 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly