I have created calendar table as calendar(min(date_refresh),max(date_refresh) date_refresh is a column which is located in my another table called business.Kindly provide solution to make default selection of max date in slicer , if my data is updated till 12-9-2021 so default selection has to be 12/9/2021 in slicer then if my data is updated till 13-9-2021 so default selection has to be 13/9/2021 in slicer and it should be displayed all dates in slicer but it should make a default selection max date
It's a bit of a hack, but if you have a date dimension you could create a column that checks for the current/max data date and groups every other date under 'future' or 'previous' so eg
[Date] > Today(), "Future",
[Date] < Today(), "Past",
Then add that to your slicer before the date column to form a hierarchy in the slicer. That way you could save the file with the 'Current' parent ticked, which would include only the current date which should update dynamically.