Need help to Calculate Current Year Week to Date (CY WTD) and Prior Year Week to date (PY WTD)

[Anonymous]

Hello All,

I need help to Calculate Current Year Week to Date (CY WTD) and Prior Year Week to date (PY WTD) in pbi. Please see screenshot below:

Our current Fiscal Year started on July 3, 2022 and runs through July 1, 2023. Our prior Fiscal Year started on July 4, 2021 and ran through July 2, 2022. You can just show me how to calculate the first two columns in the screenshot and I am pretty sure I can tweak the expression a little bit to create the other columns. 

I have created a google sheet with my fiscal calender added. The link is: https://docs.google.com/spreadsheets/d/1pjjp65zRGJjW-wWYNYFysY_tI6ZHk3putzmzCCcEk6Q/edit?pli=1#gid=1...

Any help is much appreciated!!!

Thank you all,

[vanessafvg]

i am little unclear on what you are looking for do you want the formula for cy wtd?

this is a great resource for time patterns

https://www.daxpatterns.com/week-related-calculations/

[Anonymous]

@vanessafvg  Yes, that is correct. I need the formula for CY WTD and PY WTD

[vanessafvg]

can you please provide some sample data?