YTD using week numbers

Anonymous — Fri, 05 Aug 2022 23:05:18 GMT

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

Re: YTD using week numbers

daXtreme — Sat, 06 Aug 2022 00:31:56 GMT

Week-Based Time Intelligence in DAX - SQLBI

Re: YTD using week numbers

Anonymous — Sun, 07 Aug 2022 14:52:54 GMT

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!

topic Re: YTD using week numbers in DAX Commands and Tips

YTD using week numbers

Re: YTD using week numbers

Re: YTD using week numbers