Filter two dates (A and B) based on a third date C (A before C and B after C)

[vinkun]

Hi,

For once I turn to you, marvelous community as there is a problem I can't solve after many attempts.

I have two tables, one for forecasts and another one for contracts.

I have one forecasting date and my contracts have 2 dates (start date and end date).

I would like to select (dropdown slicer) a Forecasting Date and that it filters all my contracts with the following condition :

Start Date < Forecasting Date 

End Date > Forecasting Date

It seems really easy, (and I hope it is) but I have spent many hours unsuccessfully.

Many thanks in advance,

Vincent

[v-chuncz-msft · Accepted solution]

@vinkun,

You may use SELECTEDVALUE Function and take a good look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[vinkun]

Thanks I'll have a look.

I already got the selectedvalue part, I'll read about the relative filtering, thanks. 

If the other thread solves my issue I'll mark the solution as good.

[vinkun]

Thanks I have solved my issue.

It is not exactly the way I wanted, but maybe what I wanted was impossible.

With this methodology I need to create one new measure for any column that i want to use, unless there is a way to create a table based on these filters.

I will try this and post here again if I can manage to do it.

Many thanks anyway !