Custom Fiscal Year Calendar & Week starting on Wednesday and Ends with Tuesday

DAX DAX Calculations
1

Hi everyone, I am not sure how to do this and it is very complex for me but hopefully someone could help me out on this, please.

Here is the description of the calendar I need to model and utilize for my visualizations in PowerBI:

The Company’s Fiscal Year begins every July (P1). In particular, the end of the previous fiscal year is at every last Tuesday of the month June , in particular:

Fiscal 2018 Last Day: Tuesday 25th, June

Fiscal 2019 First Day: Wednesday 26th, June

Fiscal 2019 Last Day: Tuesday 30th, June

Fiscal 2020 First Day: Wednesday 01st, July

Period 1 : July, Period 2 : August…. Period 12 : June

Q1 : JUL, AUG, SEP

Q2 : OCT, NOV, DEC

Q3 : JAN, FEB, MAR

Q4 : APR, MAY, JUN

Sample result of fiscal calendar are attached. Thank you in advance.

FinancialCalendar.xlsx (44.5 KB)

2

This link from SQLBI solves my problem. Had a little bit of tweak and voila!

1 Like
3

sorry I am seeing this so late - you may want to check out the excellent date table developed by our own Expert Melissa

1 Like
4

I downloaded and looked into your Fiscal Calendar and it seems what you need is a 4-5-4 Calendar.
You can generate this Calendar Table in Power Query using “Ultimate Calendar Table Creator”. I personally prefer Calendar Table generated in Power Query rather than DAX. I have also included Matt’s blog post on how to create 4-4-5 Calendar and modify it to create 4-5-4 Calendar that you need.

https://www.thepoweruser.com/2017/08/29/the-ultimate-calendar-table-creator-for-power-bi/

2 Likes