# ISOWEEK Calculation **URL:** \ **Category:** Q&A\ **Tags:** calculations, Business-Intelligence-Engineer, quick-sight\ **Created:** [July 2, 2024, 9:19am UTC](https://community.amazonquick.com/t/isoweek-calculation/32073 "2024-07-02T09:19:57Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![EmreKyk](https://avatars.discourse-cdn.com/v4/letter/e/e9bcb4/32.png) [@EmreKyk](https://community.amazonquick.com/u/EmreKyk)\ **Post date:** [July 2, 2024, 9:19am UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/1 "2024-07-02T09:19:58Z")
Hi, As might be known, there is a feature in tableau that calculates the number of week of year in that particular datetime value. (i.e. 25.07.2022 → W30) May I ask how this ISOWEEK based calculation can be applied in AWS Quicksight? (ISO-8601 Week Based) Many thanks in advance for your support. Best Regards. ---
**Author:** ![Shahid\_Muhammad](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/shahid_muhammad/32/24673_2.png) [@Shahid\_Muhammad](https://community.amazonquick.com/u/Shahid_Muhammad)\ **Post date:** [July 2, 2024, 11:00am UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/2 "2024-07-02T11:00:35Z")
Hi Emrekyk First you need to create ISO year and after that ISO week number and on the basis of this you were able to create iso week ---
**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\ **Post date:** [July 18, 2024, 3:51pm UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/3 "2024-07-18T15:51:49Z")
Hi @EmreKyk, It’s been awhile since we last heard from you. Were you able to come up with a solution for your original topic or do you have additional questions? If still looking for additional help, maybe check out this [article](https://gist.github.com/jjasont/09ebe6a7b09530b4d2cda075034b8c39) to see if it can assist any further. If we do not hear back within 3 business days, I’ll go ahead and mark as solved. Thank you! ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [July 22, 2024, 2:00am UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/4 "2024-07-22T02:00:16Z")
Hi @Emre_Bulbul, hope this post helps: > [@ISO WEEK of the year](https://community.amazonquick.com/t/iso-week-of-the-year/15108): > > I found out the formula to calculate week of the year in this forum and tried PFA, when I tried to debug I found out that for some weeks it is giving me the wrong result, I cross-checked with the iso week calculator. PFA, any work around for this? Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the Quick Sight Community! ---
**Author:** ![EmreKyk](https://avatars.discourse-cdn.com/v4/letter/e/e9bcb4/32.png) [@EmreKyk](https://community.amazonquick.com/u/EmreKyk)\ **Post date:** [July 22, 2024, 12:08pm UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/5 "2024-07-22T12:08:54Z")
Hi, Xclipse, @Brett , @Shahid_Muhammad sorry for late reply! Unfortunately it’s not resolved yet. Let me explain why. @Brett For [this link](https://gist.github.com/jjasont/09ebe6a7b09530b4d2cda075034b8c39) - How can we know which day was the starting day of week for each year? @Shahid_Muhammad If there is any documentation or link for ISO Year calculation, I’d be so glad if you could share. Many thanks in advance for your time and help. Best. ---
**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\ **Post date:** [July 30, 2024, 2:48am UTC](https://community.amazonquick.com/t/isoweek-calculation/32073/6 "2024-07-30T02:48:52Z")
Hi @EmreKyk, please see if this demo helps: [https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Custom-Week-Start-Day](https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Calculation-Custom-Week-Start-Day) ![2024-07-29_22-47-34](https://d1wl4jav5dp96l.cloudfront.net/original/3X/1/9/19e775fe1adc5b57fa0f3152c0d0cc6a3ffe1efb.png)