Extract value Lookup Value

[SQUILES]

HI, 

I need to get the value of 7 days ago. Example:

For 7/1/2019 i need the value of 6/24/2019

For 7/2/2019 i need the value of 6/25/2019

I try this column measure but give me a wrong value:

LookupValueofPrevDate = CALCULATE(MAX('T8 Wireless'[DATO_30]),FILTER('T8 Wireless',WEEKDAY('T8 Wireless'[DATA_PERIODO])=WEEKDAY(DATEADD('T8 Wireless'[DATA_PERIODO],-7,DAY))))

Any help will be appreciate. Thanks Again.

[VijayP]

CALCULATE(TotalSales,filter(all(dates),date[date]=date[date]<6) Try this

---

@SQUILES wrote:

HI, 

I need to get the value of 7 days ago. Example:

For 7/1/2019 i need the value of 6/24/2019

For 7/2/2019 i need the value of 6/25/2019

I try this column measure but give me a wrong value:

LookupValueofPrevDate = CALCULATE(MAX('T8 Wireless'[DATO_30]),FILTER('T8 Wireless',WEEKDAY('T8 Wireless'[DATA_PERIODO])=WEEKDAY(DATEADD('T8 Wireless'[DATA_PERIODO],-7,DAY))))

Any help will be appreciate. Thanks Again.

---

[SQUILES · Accepted solution]

@VijayP  thanks for your answer, but is not working.

May be my explination is not clear.

I need the value of 7 day ago to calculate.

For 7/1/2019 i need the value of 6/24/2019