Include 13th month in Date

[DanteL]

I have data that records the 13th month of each year, and is recorded as 202213, 202113, 202113 and so on....

The rest of the dates are also in that format e.g. 202201, 202202, 200511, and so on.

How do I structure my tables/queries in a way that includes the corresponding data associated for the 13th month of each year as well ? I'm ok with showing the months as 1, 2, 3....13 on the charts instead of the month name, since there is none for month13.

I have a date slicer that shows the Years and Months too.

I can't seem to find anything about this anywhere. Thanks.

[collinsg · Accepted solution]

Good Day @DanteL ,

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.