select most recent date from filter

[Stuartm1983]

Hi,

I have an automated report which updates each day.

I want it to keeo every day of data within the report so it can be selected by the consumer.

However I also want to update the filter to show most recent day, after refresh.

Can I do this while keeping all the other days. In the tick box of the slicer?

Thanks

[Anonymous]

Hi,

You can create measure as follow:

Latest_Date = MAX(Date_Table[Date])

Add KPI and drag-and-drop this measure to see latest date

[Greg_Deckler · Accepted solution]

@Stuartm1983 Create a colum like:

Column = 
  VAR __Max = MAX('Table'[Date])
RETURN
  IF([Date]=__Max,"Latest",[Date] & "")