topic Re: Fiscal Year and Week No with different start dates in April in DAX Commands and Tips

Fiscal Year and Week No with different start dates in April

Richard_Halsall — Tue, 04 Apr 2023 13:16:01 GMT

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

Re: Fiscal Year and Week No with different start dates in April

Wilson_ — Wed, 05 Apr 2023 00:40:46 GMT

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?)

Re: Fiscal Year and Week No with different start dates in April

Richard_Halsall — Wed, 05 Apr 2023 08:39:03 GMT

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

Re: Fiscal Year and Week No with different start dates in April

Wilson_ — Wed, 05 Apr 2023 11:39:08 GMT

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