Fiscal Month Offset and Fiscal Year Offset

[joshua1990]

Dear all,

I am working on switching from a DAX-generated calendar to a PQ-generated calendar since this approach offers more opportunities by sharing the calendar in a simple and elegant way.

I already have all essential data implemented like the gregorian and fiscal calendar structure.

I am working with a 445-approach. For instance, our year 2021 hast started on the 4th of January.

One of the last things/ information I am missing is a Fiscal Month Offset and Fiscal Year Offset.

How would you do that?

Is there any simple approach I could adapt to my calendar?

[mahoneypat]

Please see this video for how to do this.

(2) Create a custom 4-4-5 calendar that self-generates in Power BI - Power BI Tips & Tricks 23 - You...

Pat

[joshua1990]

@mahoneypat : Thanks, but nothing in the video is related to my question.

[mahoneypat]

My bad for not reading until the end.  I thought you just needed an M fiscal calendar.  Have you seen this solution for fiscal quarter offset?  You should be able to adapt it for month and year offset.

Solved: Calendar Fiscal Quarter Offset - Microsoft Power BI Community

Pat