Hi @Sohan ,
Slicers cannot be used in calculated columns. They can, however, be used in measures.
Slicers are Filters, and thus use filter context. Filters can change dynamically based on what is selected, and how filter interactions are defined. Since measures are dynamic fields calculated on demand, they can leverage this filter context to shape results.
So, you should use a measure instead of the calculated column if you would like to change the calculation in a table when the slicer value changed. as follows:
VAR _currentDate = Max(TestTable[Date])
VAR _currentDatePlusSixMonths = EDATE(_currentDate, 6)
FILTER(FactAppointment, MAX(FactAppointment[Date appointment]) >= _currentDate &&
MAX(FactAppointment[Date appointment]) <= _currentDatePlusSixMonths &&
MAX(FactAppointment[Date booking] )<= _currentDate)
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.