Filter table based on calculated measure from another Table

[Krexx]

Hello, i have two tables one table called "Orders" contains following Columns: 

Productnumber, Orderdate

And the other Table "Time" that contains only Dates from 01/01/2019 until 31/12/2021. In the Time have an calculated measure where i want to display the min(date)-6 months from the selected Filter. 

Now i would like to create a new column in the Table "Orders" where minDate <= Orderdate gives me True or False back. 

This function doesnt seem to work.
Includes = IF(RELATED(Time[minDate] <= 'Orders'[Orderdate]),TRUE,FALSE)

Has anyone an idea?

Thanks in advance

[amitchandak · Accepted solution]

@Krexx , You can not create a calculated column on the slicer  . Assume the two are related. You can get all dates/order below the selected date

measure =
var _min = minx(Date, Date[Date])
return
calculate(Count('Orders'[Orderdate]), filter(All(Date),Date[Date] <_min))

[Greg_Deckler]

@Krexx - You cannot create a column in a table that dynamically updates based on a measure if that is what you are trying to do. If I read this correctly, you are trying to do something like a Complex Selector. https://community.powerbi.com/t5/Quick-Measures-Gallery/The-Complex-Selector/m-p/1116633#M534

@ me if none of this is correct or doesn't help. Sample data and expected output would help tremendously in that case. 

Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.