Forum Discussion
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!!!
2 Replies
- AnonymousNot applicable
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!