Fiscal Year and Week No with different start dates in April

[Richard_Halsall]

Hi
Is it possible to create a Fiscal year and week number using dax in the date table with different FY start dates in April, the parameter being the first Monday of the month:

FY22      Week 1 starting Monday 5 April 2021

Week 52 ending Sunday 3 April 2022

FY23      Week 1 starting Monday 4 April 2022

Week 52 ending Sunday 2 April 2023

FY24      Week 1 starting Monday 3 April 2023

Week 52 ending Sunday 31 March 2024

Thanks for any help

[Wilson_ · Accepted solution]

Hey Richard,

I'm attaching a sample pbix I put together to solve your problem. In the pbix, I have a date table with four added columns:

• the first date of the fiscal year corresponding to the calendar date
• the fiscal year
• the week number
• the day number

Every year has 364 days, every year has 52 weeks, and every week has 7 days.

Please confirm if this is what you were looking for or if you need something different. 😄

----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

[Richard_Halsall]

That works a treat, using the Calendar Year First Date to calculate the required dates, was something I had overlooked. Thanks again

[Wilson_]

You're welcome, Richard. Happy to help. 😄