A dedicated space for high-quality, peer-led insights on how to grow, differentiate, and succeed.

Tips & Education

A client recently approached me with a somewhat 

. They needed a dashboard, but here’s the twist: In their organization, the 

 doesn’t start on January 1st like it does in most places. Instead, it begins on the 

. However, if January 1st happens to fall on a Monday, that’s when their financial year kicks off. 

The client offered $80 for the project. I did my best to tackle this challenge, but after two days of effort, I was ready to give up and cancel the order. Just then, an 

, and I decided to give it a shot — and to my relief, it worked! 

In this article, I’ll walk you through how I solved this problem. 

. Below is the code used to generate this table: 

    CALENDAR( MIN( 'Sales Data'[CustomerKey] ), MAX( 'Sales Data'[OrderDate] ) ),

 function gives us the day name of that date. If the 

 and doesn’t start on a Monday, the week will start from 

As you can see, since January 1st, 1935 is not a Monday, the year doesn’t change. Week 53 extends from 

December 31st, 1934, to January 6th, 1935

And this is how 1935 Year’s Week 1 looks like: 

Financial Year Starting on the 1st Monday Instead of January 1st

A home for meaningful connections, peer support, and professional growth.

Fiverr Community

Job Title

Login to the Fiverr Community community to connect with others, attend community events, and more!

Login or Sign Up for even more

To unlock all parts of the community and get the best experience, complete your profile.