Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
PedroDCPaula
New Member

Custom 445 Calendar?

Hello PBI Community?

Could someone help me solve an implementation, please?

Considering the fiscal year 2022, basically the Quarter ends on the last Saturday of the current Quarter, examples: Q1 (from 01/01/22 to 04/02/22), Q2 (from 04/03/22 to 07/02/ 22), Q3 (from 07/03/22 to 10/01/22), Q4 (from 10/02/22 to 12/31/22). I imagine that the ideal would be to implement something related to the day of the week such as: last Saturday or the first following Monday of the current Quarter, so the logic will be applied in previous and following years. In addition, the same happens with Fiscal Weeks, where the last closing day is Saturday, here are some examples: SF01 (from 01/01/22 to 01/08/22), SF05 (from 01/30/22 to 05/02/22), SF48 (from 27/11/22 to 03/12/22) and SF52 (from 25/12/22 to 31/12/22).

Fiscal year:

Year 2022: 01/01/22 to 12/31/22.

Fiscal quarter:

Q1 (from 01/01/22 to 04/02/22),

Q2 (from 04/03/22 to 07/02/22),

Q3 (from 07/03/22 to 10/01/22),

Q4 (from 10/02/22 to 12/31/22).

Fiscal Weeks:

FW01 (from 01/01/22 to 01/08/22),

FW02 (from 01/09/22 to 01/15/22),

FW03 (from 01/16/22 to 01/22/22),

FW04 (from 01/23/22 to 01/28/22),

FW05 (from 01/30/22 to 02/05/22),

...

FW48 (from 11/27/22 to 12/03/22),

FW49 (from 12/04/22 to 12/10/22),

FW50 (from 12/11/22 to 12/17/22),

FW51 (from 12/18/22 to 12/24/22),

FW52 (from 12/25/22 to 12/31/22).

 

I would greatly appreciate if someone could consider help me.

Thanks a lot,

1 REPLY 1
daXtreme
Solution Sage
Solution Sage

Custom calendar implementations are all available from www.sqlbi.com. You don't have to re-invent the wheel. You can start here: DAX Time Intelligence for 4-4-5 Calendar, ISO Calendar and other custom ones #dax #powerpivot - SQLB... or here: Week-related calculations – DAX Patterns

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors