MB
VAR CurrentWeek = MAX('Date'[Week of Year])
VAR CurrentYear = YEAR(MAX('Date'[Date]))
VAR Result =
CALCULATE(
[SalesAmount],
FILTER(
ALL('Date'),
YEAR('Date'[Date])=CurrentYear&&
'Date'[Week of Year]=CurrentWeek-1
)
)
RETURN
Result
VAR CurrentYear = YEAR(MAX('Date'[Date]))
VAR Result =
CALCULATE(
[SalesAmount],
FILTER(
ALL('Date'),
YEAR('Date'[Date])=CurrentYear&&
'Date'[Week of Year]=CurrentWeek-1
)
)
RETURN
Result
Благодарю!!!!!
