Custom count on number of days - POWERPIVOT

[rv328]

Please HELP

I am able to count total number of candidates from CANDIDATES TABLE (attached) columns from date applied, Recruiter interview, manager interview, Offer, Start. However i want to see see custom activity for last # days on a particular reqID

I want to see custom custom count for last 7, 14 or 30 days. Ideally i would like to add a timeline to select dates from it and see count. I have another table Req, which has a ReqID. create a dummy table for date and attached it to CANDIDATES TABLE. Was unsuccessful

CandidateID	First Name	Last Name	Phone	Data Applied	Recruiter Interview	Manager Interview	Offer	Start	ReqID
1	Ralph	Baker	55-(468)565-2453	2/10/2017	2/10/2017	2/13/2017	2/20/2017	3/14/2017	2
2	Wanda	Jackson	7-(136)148-7475	12/4/2016	2/1/2017	3/1/2017	3/13/2017	4/25/2017	1
3	Lillian	Russell	51-(863)991-7890	1/20/2017	2/27/2017	3/10/2017	3/10/2017	3/23/2017	3
4	Juan	Wheeler	33-(720)483-9674	11/11/2016	12/18/2016	1/18/2017	2/20/2017	3/20/2016	2
5	Nicholas	Murray	7-(715)193-9008	12/18/2016	2/26/2017	2/28/2017	3/3/2017	3/3/2016	1

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

here is the powerpivot

Count of Data Applied	Count of Recruiter Interview	Count of Manager Interview	Count of Offer
2	2	2	2

<colgroup><col><col><col><col></colgroup><tbody>
</tbody>

I have to use powerpivot/powerquery as i have more than 2 millions rows here

 

[rv328]

this count id for ReqID 2