Today the extract() function does not support extracting the ‘week number’ from a date field. As a workaround you can use a formula like this (may need some adjustments +/-1 for certain years, could add some ifElse logic to account for that). FYI this uses weeks starting Sun. dateDiff(truncDate("WK…

Nice, that helped a lot! For the week starting on Monday: ifelse( extract("WD", Date) = 1, dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK'), dateDiff(truncDate("WK", truncDate('YYYY', Date)), Date, 'WK')+1 ) This can be changed to any day of the week can be used as start…

Week Numbers (1-53)

Learn Technical Articles

Jesse February 14, 2023, 8:37pm 8

There’s also this page but I dont think you can subscribe to it:

Min & Max Dates for a 'Week Number' in a Pivot Table Row

formatDate() gives me an error about unsupported format

Error periodOverPeriodLastValue periodo week

Topic		Replies	Views
Week number in QuickSight Q&A calculations	2	5126	July 11, 2024
How can I extract number of week from one of my column Q&A formulas , filters , date , weeks , quicksight , Business-Intelligence-Engineer	4	114	June 10, 2024
Create date parameter in quicksight, if date='week' then extract week_number Q&A calculations , Business-Intelligence-Engineer	1	216	March 1, 2024
How to get iso week starting Sunday Q&A calculations	1	675	March 28, 2023
How to make date field of week starting on saturday Q&A analysis , formatting , date , weeks , calculations , how-to	6	2366	November 21, 2023

Week Numbers (1-53)

Related topics