How to find the unique count of people on the latest date ?

[pal25]

Hi 

I have 2 columns - one with dates and another one with people names. I want to prepare a KPI where i show the unique count of  people who appeared on the latest date (which is 10th Jan in the given example). How can i achieve this ?

Date	Person
1/1/2022	A
1/1/2022	B
2/1/2022	C
2/1/2022	A
3/1/2022	B
10/1/2022	A
10/1/2022	B
10/1/2022	C

[rubenmarin · Accepted solution]

Hi, you can try with: Count(Distinct {<Date={"$(=Date(Max(Date)))"}>} Person)

[pal25]

Thank you so much @rubenmarin . It worked  🙂