Default Current Week Number to Start at Number 1

DAX DAX Calculations
1

Hi,
My requirement is to default current week number to 1 and subsequent one on the visual to follow after that as seen in the image below:

image
image819×672 15 KB

I am to renumber the week number starting with the current week as 1 and others follow suit. I hope this is possible?

Procedures.pbix (40.6 KB)

I anticipate your help.
Thank you.

2

Hi @upwardD,

Add this column to your Dates table:

Week Offset =
VAR _StartOfWeekToday = TODAY() - WEEKDAY( TODAY(), 2 ) +1
VAR _StartOfWeekDate = 'Date'[Date] - WEEKDAY( 'Date'[Date], 2 ) +1
RETURN

((_StartOfWeekDate - _StartOfWeekToday) /7) +1

To have the current week be equal to 1 instead of zero, I’ve added one.
Next replace the Week Number in your visual by this Week Offset

I hope this is helpful.

2 Likes
3

Thank you so very much @Melissa