DAX : Calculate average for Last 4 weeks
Hi All if you have average measure and needs to calculate for last 4 weeks then create DAX like shown below using DATESINPERIOD function Average of last 4 weeks = CALCULATE([Average For Report Period],DATESINPERIOD('Date'[Day],LASTDATE('Date'[Week Ending]),-28,DAY)) Average of last 12 weeks = CALCULATE([Average For Report Period],DATESINPERIOD('Date'[Day],LASTDATE('Date'[Week Ending]),-84,DAY))