Get last value max date

[saminouari]

Hi, 

I want to get the last value from the latest date, for example : 

This is my table

Store,Date, Value
BOULANGER AGEN, 03/06/2019, 1
BOULANGER AGEN, 13/06/2019, 1
BOULANGER AGEN, 26/06/2019, 1
BOULANGER AGEN, 26/06/2019, 0
BOULANGER AGEN, 17/07/2019, 0
BOULANGER AGEN, 17/07/2019, 2
BOULANGER AGEN, 30/07/2019, 1

This is the result I want

Store, Max Date, Last Value
BOULANGER AGEN, 30/07/2019, 1

I tried FirstSortedValue but it didn't work.

[sunny_talwar]

In the script or front end

[saminouari]

@sunny_talwar  Both solutions work for me, I want to display the last value from max date of each distinct store.

[sunny_talwar · Accepted solution]

Front end solution

[saminouari]

@sunny_talwar  Your solution work fine, but when I tried to replicate it, it didn't work. I think I have a problem with the DateFormat.

[sunny_talwar · Accepted solution]

Max(Date) is an expression, not a dimension... you seem to be using it as a dimension