Last Week, Previous Week Calculation Formula Review.

[Jmenas]

Hi All,

I just want to share a DAX calculation for the last week and the previous one from the last year. This is a similar solution to this topic: Last 2 week

Previous Week Sales = CALCULATE(SUM('Sales'[Unit Sales]), 
	FILTER('Datetable', 'Datetable'[Weeknumber] = 
        WEEKNUM(MAX('Datetable'[Date]),2)-2 && YEAR('Datetable'[Date]) = 
        Year(MAX('Datetable'[Date]))),VALUES(Datetable[Date]))
	
	
Last Week Sales = CALCULATE(SUM(SUM('Sales'[Unit Sales]]), 
             FILTER('Datetable', 'Datetable'[Weeknumber] = 
             WEEKNUM(MAX('Datetable'[Date]),2)-1 && YEAR('Datetable'[Date]) 
             = Year(MAX('Datetable'[Date]))),VALUES(Datetable[Date]))

The data looks like this, but I also have a date table. 

 

The results for me, in this case, are Last week = 49 and Previous Week = 96. 
Let me know if there is a better way to do it or to make it more dynamic. 

Best,

Jorge

[v-qiuyu-msft]

Hi @Jmenas,

Thanks for your sharing.

Best Regards,
Qiuyun Yu