Show data before the selected period in relative date slicer

[Anonymous]

Hello,

I have data from ADS about workitems, comments and descriptions.
Using Invoked custom functions, i have created two tables:
table1 which contains  workitem_id, workitem_title comments_createddate
table 2 which containt workitem_id, workitem_title, description_created date

I have to display the workitems_tilte whose comments_createddate is not within the date range used as filter. 
The created_date is as a relative date slicer. example Last 1 month
I have created the measure selected date that displays the minimun date of the slicer.

selected date =

var sele = minx(ALLSELECTED('WorkItems ID'),'WorkItems ID'[Get WorkItems.comments.createdDate])

return

sele

In a table I want to display the workitems_title whose comments_createddate is before the date in the slicer. 

[Anonymous]

Hi @amitchandak 
I created a relationship between DateTbale and FactTable, but the measure to display data before the selectd period is not working. 
I have workitems with different comments.createddate sot for example if i filter the DateTable last 1 week 19.01-25.01. I want to display all workitems whose comments date is before 19.01 

[Anonymous]

@amitchandak 
I already have a Date Table but the date table is related with workitems table.
Workitems table is then related with my table1. 
The filter is not working

[amitchandak]

@Anonymous , Create a common date table and join it with both tables

new measure =
var _max = maxx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter(all('Date'), 'Date'[Date] <=_max))

or

new measure =
var _max = Minx(allselected(Date),Date[Date])
return
calculate( sum(Table[Value]), filter(all('Date'), 'Date'[Date] <=_max))

In case you need trend the slicer needs to be on an independent table 

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] <=_max))