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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
TonyAshton
Frequent Visitor

Help to create 2 x December months in a reporting period

Hi all.

 

I am after some advice on how to create 2 x December months for one reporting period as registrations for my program commence mid December in one year and finish mid December the next i.e 15 December 2024 - 14 December 2025.

 

Especially when displaying, how to get the following.

 

Dec 2024

Jan 2025

Feb 2025

Mar 2025

Apr 2025

May 2025

Jun 2025

Jul 2025

Aug 2025

Sep 2025

Oct 2025 

Nov 2025

Dec 2025


Even if Dec 2024 is Dec 1 and Dec 2025 is Dec 2 to assist as all Dec data is currently going in together at the moment.

1 ACCEPTED SOLUTION

 Hi could you try this
CustomMonthYear =
VAR CurrentYear = YEAR('Date'[Date])
VAR DecStart = DATE(CurrentYear, 12, 15)
RETURN
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] >= DecStart,
"Dec " & CurrentYear + 1,
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] < DecStart,
"Dec " & CurrentYear,
FORMAT('Date'[Date], "MMM YYYY")
)

If any of my post helped please give a kudos and accept the solution also 
Thanks in advance

View solution in original post

4 REPLIES 4
some_bih
Super User
Super User

Hi @TonyAshton seeems you need fiscal calendar which start / end in December?

If yes, in your Calendar / Date table create fiscal related columns. Check link for example and adjust to your calendar, like VAR FirstFiscalMonth = 3 in your case should be VAR FirstFiscalMonth = 12





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!






Akash_Varuna
Helper V
Helper V

Hi create a custom column and try this
CustomMonthYear =
VAR DecStart = DATE(YEAR('Date'[Date]), 12, 15)
RETURN
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] >= DecStart,
"Dec " & YEAR('Date'[Date]),
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] < DecStart,
"Dec " & (YEAR('Date'[Date]) - 1),
FORMAT('Date'[Date], "MMM YYYY")
)
)

Thanks Akash. It kind of work but displays 1 Dec - 14 Dec as the previous year. 

 Hi could you try this
CustomMonthYear =
VAR CurrentYear = YEAR('Date'[Date])
VAR DecStart = DATE(CurrentYear, 12, 15)
RETURN
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] >= DecStart,
"Dec " & CurrentYear + 1,
IF(
MONTH('Date'[Date]) = 12 && 'Date'[Date] < DecStart,
"Dec " & CurrentYear,
FORMAT('Date'[Date], "MMM YYYY")
)

If any of my post helped please give a kudos and accept the solution also 
Thanks in advance

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.