Date slicer

Thanks for the reply from Kedar_Pande and 123abc  , please allow me to provide some additional insights.

Hi Zulaikha ,

You could create a new date table based on the minimum date in your 'dim_table'.

Date = 
ADDCOLUMNS(
    CALENDAR(
        MIN('Table'[Date]),
        TODAY()
        ),
        "Year", YEAR([Date]),
        "Month", MONTH([Date]),
        "Day", DAY([Date])
    )
    

It will refresh to the current date and we could use ‘Between’ in the date slicer setting

Don't forget to create a new relationship with the fact_tables.

Could you please provide example data or sample files here if you have any confused? We could offer you more help if we have information in detail. There is sensitive data that can be removed in advance. How to provide sample data in the Power BI Forum - Microsoft Fabric Community

Thanks for your understanding. Your time and cooperation are much valued by us. We are looking forward to hearing from you to assist further.

Best regards,

Lucy Chen

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