Forum Discussion

hcze's avatar
hcze
Icon for Helper II rankHelper 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.

hcze's avatar
hcze
Icon for Helper II rankHelper II
2 years ago

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

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

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