YTD using week numbers

[Anonymous]

Hi All,

First time posting here, I hope everyone is doing well! 

I'm trying to build a YTD measure but running into an issue. The date column I'm using is week ending (we receive POS data weekly, not daily at my company). When I run YTD sales using normal time intelligence, it's pulling in sales for ending Jan 2 (see snapshot below). We consider this week to be 2021 sales, making my YTD numbers inaccurate. Note that I cannot simply calculate the week beginning for each week to "move" this week to 2021 because it causing an issue on another year.

Wondering is there's a way to run YTD sales using week numbers from the "Week" column, instead of dates. I'm able to identify the current week using a MAX function, so I am able to identify wk1 and current week's values.

Hoping this makes sense and someone has a fix. Thanks in advance!!!

[Anonymous]

Thanks @daXtreme! The answer was definitely in there. Still working through setting up my calendar correctly, but this is what I was looking for. Thanks!

[daXtreme · Accepted solution]

Week-Based Time Intelligence in DAX - SQLBI