Dynamic Date IF Statement

[Anonymous]

Hi, 

I'm trying to do a simple IF Statment but it doesn't seem to work; I'm trying to created a calculate column to use as a customer filter. 

I'm looking at 3 Columns as listed below:

1. (Measure) Date_Selected = CALCULATE(MAX('DATE'[Date]),ALLSELECTED('DATE'))
2. dwh InventoryTenancy'[Start] = Colum from data set
3. dwh InventoryTenancy'[End] = Colum from data set

In the below screen shot the highlighed "Exclude" should be "Include". 

Any help is always appricated. 

Thanks 

Dobby Libr3