Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Max(Date) is an expression, not a dimension... you seem to be using it as a dimension
In the script or front end
@sunny_talwar Both solutions work for me, I want to display the last value from max date of each distinct store.
Front end solution
@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.
Max(Date) is an expression, not a dimension... you seem to be using it as a dimension