cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
hayesla96
Frequent Visitor

Fiscal Calendar

I am trying to build a fiscal calendar that can be used as a template for all reports. However, I don't know how to build this all the way back to 1999. 

 

PeriodMonth EndWeeksDays
    
201812/30/2018  
    
2019   
11/27/2019428
23/3/2019535
33/31/2019428
44/28/2019428
56/2/2019535
66/30/2019428
77/28/2019428
89/1/2019535
99/29/2019428
1010/27/2019428
1112/1/2019535
1212/29/2019428
  52364
    
2020   
11/26/2020428
23/1/2020535
33/29/2020428
44/26/2020428
55/31/2020535
66/28/2020428
77/26/2020428
88/30/2020535
99/27/2020428
1010/25/2020428
1111/29/2020535
1212/27/2020428
  52364
    
2021   
11/24/2021428
22/28/2021535
33/28/2021428
44/25/2021428
55/30/2021535
66/27/2021428
77/25/2021428
88/29/2021535
99/26/2021428
1010/24/2021428
1111/28/2021535
121/2/2022535
  53371
    
1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @hayesla96,

I'm not so clear about your requirement,  can you please share some dummy data with a similar data structure and expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors