Select required dates from slicer selection

Hi Raman3456 ,

The Table data is shown below:

Please follow these steps:

1.Create a date table for a slicer.

Calendar = CALENDAR(DATE(2023,1,1),DATE(2024,12,31))

2.Use the following DAX expression to create a measure

MEASURE =
VAR _dateForSlicer =
    MAX ( 'Calendar'[Date] )
VAR _1MonthAgo =
    EDATE ( _dateForSlicer, -1 )
VAR _2MonthAgo =
    EDATE ( _dateForSlicer, -2 )
VAR _3MonthAgo =
    EDATE ( _dateForSlicer, -3 )
VAR _table1 =
    CALENDAR (
        DATE ( YEAR ( _dateForSlicer ), MONTH ( _dateForSlicer ), 1 ),
        _dateForSlicer
    )
VAR _table2 =
    CALENDAR (
        DATE ( YEAR ( _1MonthAgo ), MONTH ( _1MonthAgo ), 1 ),
        DATE ( YEAR ( _1MonthAgo ), MONTH ( _1MonthAgo ), DAY ( _dateForSlicer ) )
    )
VAR _table3 =
    CALENDAR (
        DATE ( YEAR ( _2MonthAgo ), MONTH ( _2MonthAgo ), 1 ),
        DATE ( YEAR ( _2MonthAgo ), MONTH ( _2MonthAgo ), DAY ( _dateForSlicer ) )
    )
VAR _table4 =
    CALENDAR (
        DATE ( YEAR ( _3MonthAgo ), MONTH ( _3MonthAgo ), 1 ),
        DATE ( YEAR ( _3MonthAgo ), MONTH ( _3MonthAgo ), DAY ( _dateForSlicer ) )
    )
VAR _dateTable =
    UNION ( _table1, _table2, _table3, _table4 )
RETURN
    SUMX ( FILTER ( 'Table', 'Table'[Creation Date] IN _dateTable ), [Revenue] )

3.Final output

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