Set a Dynamic MAX date

Hi kaweckil 

Thank you very much lbendlin for your prompt reply.

lbendlin's answer fits the situation you're looking for. Have you solved your problem? If not, allow me to add some details.

Create a column.

Max date = 
IF(
    'Table'[Date] = MAX('Table'[Date]),
    "Max date",
    FORMAT('Table'[Date], "mm/dd/yyyy")
)

Solved: How to set default MAX date in Slicer - Microsoft Fabric Community

To create a slicer, select Max date. In this case, the slicer will be updated based on your date, with the default "Max date" selected.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.