Dynamically Showing 8 Weeks based on DimDate Slicer Selection

[keel21]

Good Afternoon,

I have been sitting on this issue for hours and cannot figure it out

I want to re create an excel style table like below in Power BI for HR

The user would select the week ending selection (DimDate is related to Application Date in my model).

I want a Power BI matrix to then show the current week + the next 7 weeks and then I can create measures to calculate how many contacts, interviews etc are done. What this is doing is showing of the 66 applicants we had in the week ending 11/11, 59 were contacted that week, 6 were contacted the week ending 11/18, and so on. The Weeks in the table are the week the action (Contact, Hire, Interview) took place, but are only looking at applicants from the week selected (11/11). 

How can I do this?

[keel21 · Accepted solution]

Disregard. I found a solution