Month number not matching month name

[Russty99]

Hi Community,

i have made a very simple date table using the formula Date Table = calendarauto()

I need to add a month column in and am having trouble with the result as per the below.

Strangely only December and January are being returned. Even for the other months.

Do you know what is wrong with my formula?

thanks,

Russell

[Arul]

@Russty99 ,

try without using MONTH function inside format.
Thanks,

[Russty99]

Hi Arul,

thanks for responding. That was the formula I did use, you can see it at the top of the screenshot. I have never encountered this issue before so have no idea where it is coming from.

thanks again

[Arul]

@Russty99 ,

I saw your formula wherein you have to make small adjustments in it. You have to remove MONTH dax function from your formula.

Thanks,

[Arul · Accepted solution]

@Russty99 ,

try this 

Month = FORMAT('Date Table'[Date],"MMMM")

 Thanks,