Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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.