Displaying Today's Date - 182 days as a Week Number

DAX DAX Calculations
1

Hi, I’d like to create a text box displaying today’s date less 182 days as that week number but am unsure how to write this. It simply needs to be: Week Count = Today() - 182 days as WEEKNUM.

Can this be done?

Thanks.

2

Hi @Dplex,

Yeah just try it… Create a measure like this:

Week Count = WEEKNUM( TODAY() -182 )

Hope that solves your query

3

Hello @Dplex,

Thank You for posting your query onto the Forum.

Are you looking for a result something like this? Below is the screenshot provided for the reference -

Week Number Results

Then in that case, here’s the measure -

Week Number = 
WEEKNUM( TODAY() - 182 , 21 )

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

4

From your requirement, I am assuming that you want to use Week Count as per Financial Year (Probably starting from July 1st onwards). You might be better off creating a custom FY Week Number column in your Calendar Table created in Power Query. I am assuming that you want the week to start on Monday and the your Date Column in your Calendar Table is named ‘Date’. You can modify the query accordingly if you want the week to start on a different date.

let
FY = if Date.Month([Date]) < 10 then Date.Year([Date]) -1 else Date.Year([Date]),
FirstMonday = List.Select(List.Transform({0..6}, each Date.AddDays(#date(FY, 7,1),_)), each Date.DayOfWeekName(_) = "Monday"){0}
in
Number.RoundUp((1+Duration.TotalDays([Date] - FirstMonday))/7,0)
5

Hi Melissa,

Thanks. That’s exactly what I’m after. Cheers.

6

Hi Harsh, yes, that’s exactly what I want to create. The card is to show the user what week count the data should be at as we have a vendor using a particular week count. It’s just designed to be a report reminder. Cheers.

7

Hi Pranmag, thanks for providing that formula. Will look at that separately to understand what the syntax is calculating. Much appreciate it.