DAX - New Column Previous week Info

Anonymous — Tue, 21 Jan 2020 22:25:23 GMT

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 ..

Re: DAX - New Column Previous week Info

Anonymous — Wed, 22 Jan 2020 04:45:48 GMT

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

topic DAX - New Column Previous week Info in DAX Commands and Tips

DAX - New Column Previous week Info

Re: DAX - New Column Previous week Info