Forum Discussion
Include 13th month in Date
Good Day Anonymous ,
My thought on this would be to create a calendar table. It may look something like this.
In the data model I would relate your data's 13th month column to the calendar table (or better still if your data has an actual date, relate it to the date in the calendar table). You can then filter your data model on a conventional basis or a 13 month basis.
Hope this helps.
Solution SageGood Day Anonymous ,
My thought on this would be to create a calendar table. It may look something like this.
In the data model I would relate your data's 13th month column to the calendar table (or better still if your data has an actual date, relate it to the date in the calendar table). You can then filter your data model on a conventional basis or a 13 month basis.
Hope this helps.