undefinedthe average of the last two weeks for each day (day number)

[SzymonKl]

I would like to create a measure that will show me the average of the last two weeks' shipments for each day (day number). based on Date Table : 'SK_Invoked Function'[DayOfWeekNumber]/// day number///. The second table is 'DEHIRE_LOGS' and it contains [DEHIRED_AT] ///date time format /// and [QUANTITY] ///Decimal number///. Do you have any idea how to go about it?

[amitchandak]

@SzymonKl ,

Have these new columns in Date Table, Week Rank is Important in Date/Week Table

Week Rank = RANKX('Date','Date'[Week Start date],,ASC,Dense)
OR
Week Rank = RANKX('Date','Date'[Year Week],,ASC,Dense) //YYYYWW format

For the last 2 weeks daily Avg

Avg Last 4 weeks = CALCULATE(Averagex(Values('Date'[Date]), [Your measure]) , FILTER(ALL('Date'),'Date'[Week Rank]>=max('Date'[Week Rank])-1 && 'Date'[Week Rank]<=max('Date'[Week Rank])))