Calculate Last Date basis change in data.

[AnkitKukreja]

Hi All,

I'm trying to calculate date as per the change in my data.

Date	Cases	Country/Region
1/11/21	665223	Belgium
1/10/21	664263	Belgium
1/9/21	662694	Belgium
1/8/21	660703	Belgium
1/7/21	658655	Belgium
1/6/21	655732	Belgium
1/11/21	53538	Afghanistan
1/10/21	53489	Afghanistan
1/9/21	53400	Afghanistan
1/8/21	53332	Afghanistan
1/7/21	53207	Afghanistan
1/6/21	53105	Afghanistan
1/11/21	8586	Andorra
1/10/21	8586	Andorra
1/9/21	8586	Andorra
1/8/21	8489	Andorra
1/7/21	8348	Andorra
1/6/21	8348	Andorra
1/11/21	173	Brunei
1/10/21	173	Brunei
1/9/2021	173	Brunei
1/8/2021	173	Brunei
1/7/2021	173	Brunei
1/6/2021	172	Brunei

So ideal solution should be

Belgium	1/11/21
Afghanistan	1/11/21
Andorra	1/9/21
Brunei	1/7/2021

This is derived as per the last change in data. I'm struggling to display the last change data in my visualization.
Any help would be appreciated, please suggest a dax solution if possible, other way around would also be appreaciated.

Thanks,

Ankit

www.linkedin.com/in/ankit-kukreja1904

[Payeras_BI · Accepted solution]

Hi @AnkitKukreja ,

Regards,

[amitchandak]

@AnkitKukreja , Try a measure like

calculate(max(table[Date]), allexcept(Table,Table[Country/Region]))

or

calculate(max(table[Date]), filter(allselected(Table),Table[Country/Region]) = max(Table[Country/Region]))