Include/Exclude records based on date value in slicer

[Anonymous]

Hi,

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?

[V-lianl-msft]

Hi @Anonymous ,

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,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

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

[amitchandak]

@Anonymous , Try like

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

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

[Anonymous]

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