Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

select most recent date from filter

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 filte...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    4 years ago

    Anonymous Create a colum like:

    Column = 
  VAR __Max = MAX('Table'[Date])
RETURN
  IF([Date]=__Max,"Latest",[Date] & "")
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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