topic Re: Help to create 2 x December months in a reporting period in DAX Commands and Tips

Help to create 2 x December months in a reporting period

TonyAshton — Fri, 24 Jan 2025 10:33:14 GMT

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.

Re: Help to create 2 x December months in a reporting period

Akash_Varuna — Fri, 24 Jan 2025 12:16:14 GMT

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")
)
)

Re: Help to create 2 x December months in a reporting period

some_bih — Fri, 24 Jan 2025 12:16:45 GMT

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

Re: Help to create 2 x December months in a reporting period

TonyAshton — Fri, 24 Jan 2025 23:15:59 GMT

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

Re: Help to create 2 x December months in a reporting period

Akash_Varuna — Sat, 25 Jan 2025 04:58:26 GMT

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