Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

YTD using week numbers

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!!!