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.

Anonymous's avatar
Anonymous
Not applicable
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.