Forum Discussion

hcze's avatar
hcze
Helper II
2 years ago
Solved

Help with calendar

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...
ADDCOLUMNS
calendar
Date
  • Anonymous's avatar
    Anonymous
    2 years ago

    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's avatar
bhanu_gautam
Super User
2 years ago

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's avatar
hcze
Helper II
2 years ago

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

  • bhanu_gautam's avatar
    bhanu_gautam
    Super User
    2 years ago

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