topic Help with calendar in DAX Commands and Tips

Help with calendar

hcze — Thu, 18 Jul 2024 11:22:53 GMT

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.

Re: Help with calendar

bhanu_gautam — Thu, 18 Jul 2024 11:50:01 GMT

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")
)

Re: Help with calendar

hcze — Thu, 18 Jul 2024 11:57:52 GMT

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

Re: Help with calendar

bhanu_gautam — Thu, 18 Jul 2024 12:08:12 GMT

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

Re: Help with calendar

Anonymous — Mon, 22 Jul 2024 09:17:56 GMT

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.