counter value within last 7 days

[amien]

i have this table:

key, unique address, date, #counter

1, 100, 20160101, 1

2, 100, 20160102, 1

3, 100, 20160502, 1

i need this result in a straight table

dim_address, dim_date, expression

100, 20160101, 1

100, 20160102, 2  <---

100, 20160502, 1

<-- this record does a sum(#counter) but looks for the last 7 days. It therefor has a hit on 20160101 and shows 2.

What expression do i need for this? Point in time is not working in this case.

Thanks in advanced

[amien]

Thanks. i went for the AsOf solution.

[sunny_talwar]

Great choice