topic Date (Year) showing as 0201 instead of 19XX in DAX Commands and Tips

Date (Year) showing as 0201 instead of 19XX

Anonymous — Fri, 18 Mar 2022 17:27:07 GMT

Hi there,

I'm trying to create a Calendar Table, using the CALENDARAUTO function, but for some reason, the format in the year is a list of numbers starting on 0201 and going on beyond 3401, etc. This is happening only in the new crated calendar table, the others show the regular format "3/9/2022".

I tried with the formating options but without success.

Why is this happening and more important, how can I get back to a regular format (1986, 2001, etc) in the years?

THANKS in advance 🙂

Re: Date (Year) showing as 0201 instead of 19XX

Whitewater100 — Fri, 18 Mar 2022 20:36:29 GMT

HI:

Looks like you can use:

Year = FORMAT(Calendar[Date], "yyyy")

Re: Date (Year) showing as 0201 instead of 19XX

Anonymous — Fri, 18 Mar 2022 21:08:44 GMT

I tried but get the same odd format 0201...

Re: Date (Year) showing as 0201 instead of 19XX

Whitewater100 — Fri, 18 Mar 2022 21:17:18 GMT

I would start over and use CALENDAR function. Clendar auto searches all your columns from all of your tables and creates a potentially massive calendar. It can pick up on peoples birhdates and such. I never use it. Try CALENDAR function. Here's an example for a calendar for 2021 -2022.

Go to Modeling > New Table.

DATES = CALENDAR(DATE(2021, 1, 1), DATE(2022,12,31))

You can select add new column to put in Year on this new table.

YEAR = YEAR(Dates[Date])

MONTH No. = MONTH(Dates[Date])

Month Name = FORMAT(Dates[Date],"mmm")

Week No. = WEEKNUM(Dates[Date])

etc.