Forum Discussion

ratercero's avatar
ratercero
Icon for Helper III rankHelper III
8 years ago

Timeline Slicer - 2017 with 53 Weeks

Hello, 2017 only has 52 weeks and this visual is showing 53 moving week 1 of 2018 to the second of 2018.   Can anyone help me adjust this?         Thanks
Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

ratercero - While not documented, you can potentially use 21 as the last WEEKNUM parameter to force 52 weeks.

 

WeekNum21 = WEEKNUM([Date],21)
AStolk's avatar
AStolk
Frequent Visitor
8 years ago

ratercero Works great! Many thanks!