Variable Date Filter

[FelixBI]

Hello,

My problem is setting a variable date filter/restriction on multiple reports.

I have four reports which all share the same dataset. The goal is that the endusers can't see the data beyond a certain date.

The date is entered from a manager after he reviews the data and it gets read into a table. 

Id	Modul	Key	Wert	Datum
19	-	Report1	202301	31.01.2023
20	-	Report2	202301	31.01.2023
21	-	Report3	202301	31.01.2023
22	-	Report4	20230101	01.01.2023

Key refers to the report the date should be applied to. 

Table with the desired date value

 I can manualy set the date filter to my specified date, but i don't know how i can implement it to change variable every month. 

Is there a possibility to implement this? 

Alternatively it would also help if there would be a way to just restrict this date slicer to only allow the selection of the specified month. 

Year and Month

Thank you for your help. 

[johnt75 · Accepted solution]

You could add extra columns to the date table, one for each report, which defines whether that date is visible in that report. Use LOOKUPVALUE to get the appropriate date from the entered table and if the current date is less than or equal to that then return true.

You can then apply report level filters on the appropriate column in each report.

[FelixBI]

Thank you very much. It worked