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

[Iwin]

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,

[justISO]

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.