Pick Dates To Align Data Set By

[crider816]

Hey friends,

Just trying to get some comparison going on for different weeks and I was wondering if there was a way to use DAX to align a series of data based on a given date
Basically I want to Pick a date and then compare a "like" week from a year prior and a month prior. Is there a way to do this in Dax? I think so. I'm pretty decent at DAX formulas so even pointing me in the right direction will be helpful.

-------------------
Here's an Example.
User Prompt (by slicer or something of the like): "Align by:" And they could select First Sunday. 2nd Sunday and

I want the data set to come out looking like.

Saturday

Friday

Thursday

Wednesday

Tuesday

Monday

Sunday

<tbody>
</tbody>

1/9/2016

1/8/2016

1/7/2016

1/6/2016

1/5/2016

1/4/2016

1/3/2016

<tbody>
</tbody>

LINE OF DATA

1/10/2015

1/9/2015

1/8/2015

1/7/2015

1/6/2015

1/5/2015

1/4/2015

<tbody>
</tbody>

LINE OF DATA

12/12/2015

12/11/2015

12/10/2015

12/9/2015

12/8/2015

12/7/2015

12/6/2015

<tbody>
</tbody>

LINE OF DATA
Summary Stats
-------------------

I could do this in VBA obviously but I'd much rather utilize DAX and power query without the hassle of importing directly to an excel sheet.

I have been using a method where I divide the Day # in the year by 7 and a roundup to calculate an "effective week" and then matching on that but with Pivot tables it throws me off when I try to do a month back. Any help is greatly appreciated.

 

[crider816]

I figured it out by utilizing a nTH day of Month function [RoundUp(Date +1 - Date(Year,Month,1)/7,0)]
and I'm just starting the different series by using the VLOOKUP equivalent in DAX LOOKUPVALUE
https://msdn.microsoft.com/en-us/library/gg492170.aspx

Table Set up like

Date	Day of Week	Month	Year	nTH day of Month
1/1/2008	Tuesday	January	2008	1

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