Creating a new Date Table that allows you to filter for a Date range on another table with multiple

[Anonymous]

I am trying to create a Date filter that allows me to filter for a date range from another table that has multiple date columns.

I have tried creating several Dax Functions for this so in a quick note what am trying to do is to be able to filter for Date range say Next 2 Weeks from Columns 'EST', 'PVOD' and 'TH' in Table A, such that the result filters for any dates available within the date range selected.

I have also included a screen shot of my table. 

I would appreciate any help with this.

Thanks.

Ben

[Anonymous]

So i realised it was better to create a calculated column within the same table using 

New Column = IF([PVOD]<=[EST], [EST], [PVOD])

[Greg_Deckler]

@Anonymous This thread contains a number of ways of doing this. https://community.powerbi.com/t5/DAX-Commands-and-Tips/No-CACULATE-challenge/m-p/3147810#M112679

[Anonymous]

@Greg_Deckler Many thanks for the link but there are too many options and i cant start trying them all and also it looks like the Dax Functions unsed in the thread are for calculating sales data while i want one that allows me to filter date range.