I would like to change the date daily by clicking on the arrow. Selected date should be changed daily by clicking on the arrows. Is this even possible ? many thanks in advance.
I need something more interactive.
_DateTable = CALENDAR(DATE(2020,1,1), DATE(2030,12,31))
_SelectedDate = TODAY()
_NextDate =
CALCULATE(
MIN(_DateTable[Date]),
FILTER(_DateTable, _DateTable[Date] > [_SelectedDate])
)
_PreviousDate =
CALCULATE(
MAX(_DateTable[Date]),
FILTER(_DateTable, _DateTable[Date] < [_SelectedDate])
)


