Filter Date Slicer To Only Show Months With Full Data

Hi All,

I have a dataset where three of my tables are excel tables that I have to update manually. I want to filter the date slicer visual (Month&Year) on the report page to only allow selections of months when the data is complete for that month.

In other words if the max date of any of the 3 tables is in September 2021 only allow to select up to August 2021 because the data for September isn't complete.

Here is an example of my three tables:

Temp Hours

Punch_Report

Warehouse Errors: (Max of any of the date fields, if this is too hard my relationship is to 'Date of Occurence' so can just use that one)

Date Table (Just 2 of my many columns in the date table. I use this one)

My dataset is already slow so I would appreciate any quick performing DAX rather than calculated columns.

Thanks in advance!