How to convert 4-5-4 calendar to Normal Calendar

[#1]

Hi,

We have 4-5-4 retail calendar, how to convert this calendar to normal calendar?

Thanks,

[#2]

Hi,

I hope some one has worked on this scenario, can you please help me here.

Thanks,

[rupamjyotidas]

Try this solution

Canonical Date

[Anonymous]

The specific of the 4-5-4 calendar is that it uses retail periods, more or less approximate to months, with length of 4 weeks, 5 weeks, and 4 weeks in each retail quarter.  So, you need to use "normal" months and quarters instead of the retail periods.  If you have Date field, the Month-Year will be:

Date(monthstart(Date), 'MMM-YYYY') as MonthYear

Quarter:

'Q' & ceil(month(Date)/3) & '-' & year(Date)

[marcus_sommer]

This one: 4-5-4 Master Calendar is the opposite and I think you could reverse the logic and/or use them as mapping to your calendar.

- Marcus

[#6]

Hi,

Thanks for your valuable posts, I got it.

Thanks,