Forum Discussion
Solved
Creating a custom Week Number variable in a date table
Hi all. I need to create a Week Number column in a date table, but the WEEKNUM function doesn't produce quite the right results. For the purposes of this variable, weeks start on Sunday. The part...
try adding a calculated column with this formula
=WEEKNUM( [Date] + 1, 21 )
Anonymous
This will answer your question:
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
Anonymous
This will answer your question:
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers