Help with calendar

[hcze]

Hi, I have a baffling issue creating column Month (see the screenshot) where the date column will change to the next month.

Without adding column Month - table values are correct

Add Month column - the date column is wrong

Any hints are appreciated.

Thanks.

[v-nuoc-msft · Accepted solution]

Hi @hcze 

@bhanu_gautam Thank you very much for your prompt reply, please allow me to share some content here.

I made changes to your code:

CalendarMe = 
ADDCOLUMNS(
    CALENDAR(DATE(2024,1,1), DATE(2025,12,31)),
    "Year", FORMAT(YEAR([Date]), "0000"),
    "Month Number", FORMAT(MONTH([Date]), "00"),
    "Day", FORMAT(DAY([Date]), "00"),
    "Month", FORMAT([Date], "mmmm")
)

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[bhanu_gautam]

@hcze , Use the below DAX

CalendarTable =
ADDCOLUMNS(
CALENDAR(DATE(2024, 1, 1), DATE(2025, 12, 31)),
"Year", YEAR([Date]),
"Month Number", MONTH([Date]),
"Day", DAY([Date]),
"Month", FORMAT([Date], "MMMM")
)

[hcze]

Thanks! It does not make sense that the sequence could cause that issue.

[bhanu_gautam]

@hcze , the issue seems with format function remove 00 then try