Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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])))