Extract value Lookup Value

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.

 

---