Finding maximum value of previous week

[freceena]

I want to calculate the difference between max(particular week for eg. week 21) - max(previous week for eg. week 20). I tried the following expression in expression editor :

max([Counter])-max({$<Date={">=$(=Date(WeekStart(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))<=$(=Date(WeekEnd(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))"}>}[Counter])

Could anyone please help me on this?

[MayilVahanan · Accepted solution]

Hi @freceena 

max([Counter])-max({$<Date={">=$(=Date(WeekStart(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))<=$(=Date(WeekEnd(Max([Date of Measurement]),-1, 0),'DD-MM-YYYY'))"},Year=,Week=,Month=>}[Counter])

Your expression looks correct , just need to exclude the Time filter in the expression.