Week number in QuickSight

[Prachi]

How can we get week number in QuickSight?
Example is as below :

Week	Week no
May 15th, 2022	20
May 8th, 2022	19

[JoseB-aws]

Hello,
This is a great post explaining how to do it:

Week Numbers (1-53)

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", truncDate('YYYY', {order_date})), {order_date}, 'WK')+1