Get values from previous week of selected week

[jaco1951]

Hi

I am not able to get the sum of amount from previous week. It seems like the second filter in my expression is causing the trouble...

cash_lastWeek = 
CALCULATE(
	SUM(
		factTable[amount]
	);
	FILTER(
		ALL(calendar); 
			calendar[YearWeek] = MAX(calendar[YearWeek]) - 1);
	FILTER(
		factTable;factTable[dataSource] = "CashReport")
)

Removing the filter for "CashReport" the values seems to follow changes in "YearWeek" field.

Br Espen

[rocky09]

something like this?

pre_sales = var enddate = MIN(Table2[Date])-1
var startdate = enddate - 6
return
CALCULATE(SUM(Table2[Amt]),DATESBETWEEN(Table2[Date],startdate,enddate),ALLSELECTED(Table2[WeekNumber])
)

[jaco1951 · Accepted solution]

I figured out somthing that does work, it might not be the most delicate solution.

Here's what I did:

prev_Cash = CALCULATE(
SUM(factTable[amount]);
	FILTER(ALL(calendar); calendar[YearWeek] = MAX(calendar[YearWeek]) - 1);
	FILTER(ALL(factTable[dataSource]);factTable[dataSource] = "CashReport"))