Filter the item count by how many of your dates are within a relative date of another column

[Anonymous]

In the last column, each CS Playbook task has an associated date, which is the next step date of CS (2th column). I would like to filter the count of the last column by how many of them fall within a relative date after the full deployment date.

For example, in the first row, the CS Playbook task count is 11. Assume that you just wanted that count to include CS playbook tasks that are within 6 months of the deployment end date. Instead of 11, that could be only 9.

Each row has a unique full deployment date, so the filter would have to be row-specific.

Please help me! Thank you!

[amitchandak]

@Anonymous 

, Not very clear, see if this blog can help

https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970

Or this file can help

https://www.dropbox.com/s/yuv64v0cneseghx/value%20Split%20between%20months%20start%20end%20date.pbix?dl=0

https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0