Forum Discussion

willclein's avatar
willclein
Icon for Helper I rankHelper I
9 years ago
Solved

[DAX] FORMAT Month not working properly

I'm having an issue where the FORMAT function for Month is only returning January and December. I originally tried:   SHIP MONTH = format(month('Table'[DATE]), "MMMM")   and was only getting Janu...
Need Help
  • Sean's avatar
    Sean
    9 years ago

    willclein just get rid of MONTH => Ship Month = FORMAT ( 'Table'[Date], "MMMM" )

Sean's avatar
Sean
Icon for Community Champion rankCommunity Champion
9 years ago

willclein just get rid of MONTH => Ship Month = FORMAT ( 'Table'[Date], "MMMM" )

willclein's avatar
willclein
Icon for Helper I rankHelper I
9 years ago

Sean I can't believe I didn't realize this was the error. Thanks for your help!