Dax

Hi everybody.

I recived weekly data in excel, all data have a column (date) and comes for the day that i recived data in (Thursday). So I created dashboard contains all weekly data and I can compare with previous week. for the comparison I used these formulas (

weekNum = WEEKNUM('Date'[Date])

WeekEndDate = 'Date'[Date]+7-1*WEEKDAY('Date'Date],1)

WeekStartDate = 'Data'[Data]+-1*WEEKDAY('Date'[Date],1)+5

WeekRang = RANKX(ALL('Date'),'Date'[WeekStartDate],,ASC,Dense)).

Also, I have filter represents all dates so I can select any date and compare it with previous week.

Today, I recived data by month and I want adjust my formula to work with both.

*Note: I can not sum weeks to get data for months. 

Thanks.