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 Month column - the date column is wrong

 

Any hints are appreciated.

 

Thanks.

 

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.

4 Replies

  • 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.

  • 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.