cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SQUILES Frequent Visitor
Frequent Visitor

Extract value Lookup Value

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.
 
LookupValue.JPG
1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
SQUILES Frequent Visitor
Frequent Visitor

Re: Extract value Lookup Value

@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

 

 LookupValue2.JPG

View solution in original post

2 REPLIES 2
VijayP Regular Visitor
Regular Visitor

Re: 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.
 
LookupValue.JPG

 

Highlighted
SQUILES Frequent Visitor
Frequent Visitor

Re: Extract value Lookup Value

@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

 

 LookupValue2.JPG

View solution in original post

Helpful resources

Announcements
New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)