DAX - New Column Previous week Info

[Anonymous]

Hi 

Can you help me with a DAX using the below example I have higlighted in YELLOW? 

I tried New Col = IF(SELECTEDVALUE(Week No) = "W05", MAX(Status), (Week No) = "W04"

which I knew it would not work .. 

[JustJan]

Hi @Anonymous ,

Try this: 

Last Week = 
var LastWeeksDate = min('SalesStatus'[Date]) - 7
var Result = CALCULATE(min('SalesStatus'[Status]), AllEXCEPT('SalesStatus',SalesStatus[Opportunity_ID]), 'SalesStatus'[Date] = LastWeeksDate) 
return 
if (not ISBLANK(Result),Result,"na")

It works for the sample set.

Jan