Linking table filters based on dates

[Dr_Doctor]

This may be a simple request of someone in this group, I've used many solutions and am throughly impressed by the vast knowledge base this community has. My power BI seat time is only around 80 hours right now, so please excuse any incorrect technical terms or misused vernacular...

What I have are 3 tables (two shown in the attachments) that need to be able to filter data and exclude the previous range.

For example, my first table filter is set to "the next 14 days", I need my next table to inherently project data for the next 30 days and exclude the prior table's dates. Same for the 3rd, project for 60 days but exclude the data from tables 1 and 2.

Thank you in advance for any solutions you can provide, the simpler the better as I am locked into using an older version of PBI by our administrative team.

 

 

 

 

[amitchandak]

@Dr_Doctor , What I am getting this the case of a disconnected slicer . Both slcier needs to on disconnected table and then you can manage like

Date Range Using 2 slicer =
var _max =Values(Date1[Date])
var _min = Values(Date2[Date])
return
calculate(countrows(Table), Filter(Table,Not Table[Date] in _max && Table[Date] in _min) )

Need of an Independent/disconnected Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

Power BI How to use/compare two Date/Period slicers: https://youtu.be/WSeZr_-MiTg

[Dr_Doctor]

@amitchandak , sir I appreciate that you took the time to attempt to assist, and the status you've built within this community, but I cannot follow the logic on your videos. I've attempted to recreate your solution a few times (8) this morning with 1 half successful attempt. 

It's probably due to a combination of my limited exposure in PBI and our two distinct styles of communication. It's almost impossible for me to learn a process when half the solution appears to have been done for 0 reason other than to demonstrate how not to proceed, and then the rest of the video is an actual solution with disregard to the first section. 

Thank you for your time, but I'm going to need additional resources on this project.