Forum Discussion

Justair07's avatar
Justair07
Icon for Resolver I rankResolver I
7 years ago
Solved

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: and I have a custo...
Need Help
  • PattemManohar's avatar
    PattemManohar
    7 years ago

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

     

PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

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's avatar
Justair07
Icon for Resolver I rankResolver I
7 years ago

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