How to get latest date in list after refresh

[darrennhg]

Hi EVERYONE,

Every time I refresh my report, I can't seem to find a way to have it automatically select the latest date when I first open the report up. It will always automatically select previous days.

So above is an example, I open the report after the refresh and it has selected the day before rather than today. Can someone help me?

[darrennhg]

Ok I'll let you know how it goes probably tomorrow

[amitchandak · Accepted solution]

@darrennhg , As of now you have to use a workaround. There was some discussion on the default date on LinkedIn, which might come soon

a new column = if(max(Table[Date]) = Table[Date] , "Latest Date", [Date] & "" )

then save it on latest date , you can mark Date as sort column