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


[TABLE="width: 1212"]
<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]CandidateID[/TD]
[TD]First Name[/TD]
[TD]Last Name[/TD]
[TD]Phone[/TD]
[TD]Data Applied[/TD]
[TD]Recruiter Interview[/TD]
[TD]Manager Interview[/TD]
[TD]Offer[/TD]
[TD]Start[/TD]
[TD]ReqID[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Ralph[/TD]
[TD]Baker[/TD]
[TD]55-(468)565-2453[/TD]
[TD="align: right"]2/10/2017[/TD]
[TD="align: right"]2/10/2017[/TD]
[TD="align: right"]2/13/2017[/TD]
[TD="align: right"]2/20/2017[/TD]
[TD="align: right"]3/14/2017[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Wanda[/TD]
[TD]Jackson[/TD]
[TD]7-(136)148-7475[/TD]
[TD="align: right"]12/4/2016[/TD]
[TD="align: right"]2/1/2017[/TD]
[TD="align: right"]3/1/2017[/TD]
[TD="align: right"]3/13/2017[/TD]
[TD="align: right"]4/25/2017[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Lillian[/TD]
[TD]Russell[/TD]
[TD]51-(863)991-7890[/TD]
[TD="align: right"]1/20/2017[/TD]
[TD="align: right"]2/27/2017[/TD]
[TD="align: right"]3/10/2017[/TD]
[TD="align: right"]3/10/2017[/TD]
[TD="align: right"]3/23/2017[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Juan[/TD]
[TD]Wheeler[/TD]
[TD]33-(720)483-9674[/TD]
[TD="align: right"]11/11/2016[/TD]
[TD="align: right"]12/18/2016[/TD]
[TD="align: right"]1/18/2017[/TD]
[TD="align: right"]2/20/2017[/TD]
[TD="align: right"]3/20/2016[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Nicholas[/TD]
[TD]Murray[/TD]
[TD]7-(715)193-9008[/TD]
[TD="align: right"]12/18/2016[/TD]
[TD="align: right"]2/26/2017[/TD]
[TD="align: right"]2/28/2017[/TD]
[TD="align: right"]3/3/2017[/TD]
[TD="align: right"]3/3/2016[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

here is the powerpivot
[TABLE="width: 614"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD]Count of Data Applied[/TD]
[TD]Count of Recruiter Interview[/TD]
[TD]Count of Manager Interview[/TD]
[TD]Count of Offer[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]2[/TD]
[/TR]
</tbody>[/TABLE]


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

 

[rv328]

this count id for ReqID 2