Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Include/Exclude records based on date value in slicer


I have a Date Dimension table  and use a slicer (from and to) to filter several transactional tables linked to a Job table. This works fine and I get the results I need.


I now have to include/exclude jobs in the Job table where the job created date is less than or equal to the To date in the above slicer.


How can I do this?

Community Support
Community Support

Hi @JasCo ,


Create a disconnected date table as a slicer.

Table 2 = CALENDAR(MIN('Table'[date]),MAX('Table'[date]))

Create a measure and apply it to visual level filter:

Measure = IF(MAX('Table'[date])<=SELECTEDVALUE('Table 2'[Date]),1,0)



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

Thank you Liang, you're suggestion has halped me to solve the problem.

Super User
Super User

@JasCo , Try like


measure =
var _max = maxx(allselected('Date'), 'Date'[Date])
var _tab = summarize(filter(Job, Job[created date] <= _max), job[Job])
calculate([measure], filter(Job, Job[Job] in _tab))


Assume Date table and Job table are joined to table of measure

Thank you Amit, your suggestion has helped me to solve the problem.

Helpful resources

Vote for T-Shirt Design

Power BI T-Shirt Design Challenge 2023

Vote for your favorite t-shirt design now through March 28.

March 2023 Update3

Power BI March 2023 Update

Find out more about the March 2023 update.

March Events 2023A

March 2023 Events

Find out more about the online and in person events happening in March!