Forum Discussion
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 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 Create a colum like:
Column = VAR __Max = MAX('Table'[Date]) RETURN IF([Date]=__Max,"Latest",[Date] & "")
2 Replies
Anonymous Create a colum like:
Column = VAR __Max = MAX('Table'[Date]) RETURN IF([Date]=__Max,"Latest",[Date] & "")