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] & "")
Greg_Deckler's avatar
Greg_Deckler
Community Champion
4 years ago

Anonymous Create a colum like:

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