Dax

[fahadrq]

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.

[tamerj1]

Hi @fahadrq 
What do you mean by "Today, I recived data by month"? Please provide sample of the newly recieved data.

[fahadrq]

aggregated data for one month.

thanks