YTD Sales till previous ISO week

[okl]

Hi 

Pls help to correct my DAX, Im trying to get the total Sales Amount till previous week (01 Jan to the MAX iso week  -1)

Sales Amount YTD till Prev Week = 
CALCULATE(
    SUM('Sales'[Amount]),
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] = MAX('Date'[ISO Week Number]) -1
    )
)

[Ahmedx]

Sales Amount YTD till Prev Week = 
  VAR _lastWeekNumber = MAXX(ALL('Date'),[ISO Week Number])
  VAR _lastDate = CALCULATE(MAX('Date'[Date]),'Date'[ISO Week Number]=_lastWeekNumber-1)
  VAR _CurrentYear = YEAR(_lastDate)
  VAR _RESULTS= 
  CALCULATE(SUM('Sales'[Amount]), 'Date'[year]=_CurrentYear&&'Date'[Date]<=_lastDate)

OR
Sales Amount YTD till Prev Week = 
  VAR _lastWeekNumber = LASTNONBLANK('Date'[ISO Week Number],[Amount])
  VAR _lastDate = CALCULATE(MAX('Date'[Date]),'Date'[ISO Week Number]=_lastWeekNumber-1)
  VAR _CurrentYear = YEAR(_lastDate)
  VAR _RESULTS= 
  CALCULATE(SUM('Sales'[Amount]), 'Date'[year]=_CurrentYear&&'Date'[Date]<=_lastDate)

[Ahmedx]

Sales Amount YTD till Prev Week = 
  VAR _lastDate = CALCULATE(MAX('Date'[Date]),'Date'[Date] = MAX('Date'[ISO Week Number]) -1)
  VAR _CurrentYear = YEAR(_lastDate)
  VAR _RESULTS= 
  CALCULATE(SUM('Sales'[Amount]), 'Date'[year]=_CurrentYear&&'Date'[Date]<=_lastDate)

[okl]

incorrect syntax

[Ahmedx]

no need to copy but need to write by hand
and you need to have year column in calendar table

[okl]

there is Year column still got the same syntax error 

[Ahmedx]

do you have this column in your calendar table?

[okl]

Yes i have or is it possible to modify from this code?

Volume = 
VAR _lastDate =
CALCULATE ( MAX ( 'DP_volume'[in_date] ), REMOVEFILTERS ( 'Date' ) )

VAR _lastWeekNumber =
CALCULATE (
MAX ( 'Date'[ISO Week Sequential] ) -1,
'Date'[Date] = _lastDate,
REMOVEFILTERS ( 'Date' )
)

VAR _result =
CALCULATE (SUM('DP_volume'[TEUs]),
'Date'[Year] && 'Date'[Date] <= _lastDate,
REMOVEFILTERS ( 'Date' )
)
RETURN (
_result
)

[Ahmedx]

Volume = 
VAR _lastDate =
CALCULATE ( MAX ( 'DP_volume'[in_date] ), REMOVEFILTERS ( 'Date' ) )

VAR _lastWeekNumber =
CALCULATE (
MAX ( 'Date'[ISO Week Sequential] ) -1,
'Date'[Date] = _lastDate,
REMOVEFILTERS ( 'Date' )
)
VAR _CurrentYear = YEAR(_lastDate)
VAR _result =
CALCULATE (SUM('DP_volume'[TEUs]),
'Date'[Year] =_CurrentYear&& 'Date'[Date] <= _lastDate,
REMOVEFILTERS ( 'Date' ))
RETURN 
_result

[Walter_W2022]

I think you just change from "=" to "<=" for YTD accumulated sales , please see below

'Date'[Date] <= MAX('Date'[ISO Week Number]) -1

Sales Amount YTD till Prev Week = 
CALCULATE(
    SUM('Sales'[Amount]),
    FILTER(
        ALL('Date'[Date]),
        'Date'[Date] <= MAX('Date'[ISO Week Number]) -1
    )
)