Forum Discussion
Solved
Changing week numbering
How can I edit the numbering from WeekNum to offset by a week while also starting each week on a Monday?
Hi,
Please check the below picture and the attached pbix file.
WeekNumber CC = WEEKNUM( 'Calendar'[Date], 21)
4 Replies
Hi,
Please check the below picture and the attached pbix file.
WeekNumber CC = WEEKNUM( 'Calendar'[Date], 21)Thank you, worked great
Hi,
Depends on which system you want, it can be :
= WEEKNUM('Table'[Date] , 21 )
or
= WEEKNUM('Table'[Date] , 2 )
or
= WEEKNUM('Table'[Date] , 11 )
to choose between thosse, please refer to :
https://docs.microsoft.com/en-us/dax/weeknum-function-dax
or
Maybe the second link is more precise
how can i change the date/time so that each date starts at 6:00 am instead?
