Year- to Week calculation

[Anonymous]

Dear all,

is it possible to calculate instead of Year  - to - Date ?  Year to Calendarweek ? 

meaning as soon as i set a slicer to a certain calendar week it will calculate the value until the specific calendar week ?

kindest regards,

Miguel

[amitchandak · Accepted solution]

@Anonymous , Check the solution provided by @Shishir22 .

Or with help from a date table

YTD= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Week] <= Max('Date'[Week]) ))
LYTD = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Week] <= Max('Date'[Week])))

[Anonymous]

thanks ! it worked

[Shishir22]

Hello @Anonymous ,

You can set weeknumber to slicer and set it to Less then or equal to as shown below.

Please mark it as answer if it solves your issue. Kudos are also appreciated.