FORMAT for Month not Correct

[Justair07]

Hi everyone,

I've done this a dozen times but I am pulling my hair out trying to understand why this is being so difficult. I have a simple Dates Table created from DAX:

and I have a custom column creating the Month Num

Month Num = FORMAT('tblDates'[Date], "m")

and then comes the headache where my custom column for Month will not work (see picture):

[PattemManohar · Accepted solution]

@Justair07  Can't see any issue with your MonthName DAX formula... Did you tried this way ?

Test240DateGen = CALENDAR("2018-01-01","2018-12-31")

Then New Columns as 

MonthNum = FORMAT([Date],"m")

MonthName = FORMAT([Date],"mmm")

[Justair07]

@PattemManohar  That did the trick! So it was an issue with the way the DAX created my dates. Thank you so much!