cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Justair07 Member
Member

FORMAT for Month not Correct

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:

Capture1.JPG

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

Capture.JPG

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: FORMAT for Month not Correct

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

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





2 REPLIES 2
Super User
Super User

Re: FORMAT for Month not Correct

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

 



Did I answer your question? Mark my post as a solution !

Proud to be a Datanaut !





Highlighted
Justair07 Member
Member

Re: FORMAT for Month not Correct

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