Fiscal Month in MMM-YY format from Date in MM YYYY format

Iwin — Tue, 05 Apr 2022 18:32:10 GMT

Hi ,

I want to get Fiscal month in MMM YY format from Date which is in MM YYYY format.

eg: 12 2021 should show Mar 22 But currently date shown is Dec 21 which is as per calendar month.

How to show it as per fiscal calendar?

I have used below expression but it is giving as per calendar month and not fiscal month:

date(date#([Fiscal year/period],'MM.YYYY'),'MMM YY') as Date,

Re: Fiscal Month in MMM-YY format from Date in MM YYYY format

justISO — Wed, 06 Apr 2022 09:09:44 GMT

Hi, my suggestion would be to push your calendar date by 3 months to get fiscal date (and create it as a separate dimension not to lose your calendar date), but the logic would be to convert MM.YYYY to date (as you already know how), add 3 months if your fiscal year starts at April, and convert that date to new format 'MMM YY':

date( AddMonths( Date(Date#([Fiscal year/period],'MM.YYYY')), 3) , 'MMM YY').

In load script you also just can play around with

SET FirstMonthOfYear=1;

line and write 4 instead, to push calendar.

topic Re: Fiscal Month in MMM-YY format from Date in MM YYYY format in App Development

Fiscal Month in MMM-YY format from Date in MM YYYY format

Re: Fiscal Month in MMM-YY format from Date in MM YYYY format