MID function to know which month it corresponds to

[Syndicate_Admin]

Hi I have this feature

MonthName = UPPER(LEFT(FORMAT([Date], "MMMM"), 1)) & LOWER(MID(FORMAT([Date], "MMMM"), 2, ONLY(FORMAT([Date], "MMMM")) - 1)) which per row should show which month it corresponded to, but now it no longer works for me, does anyone know what could be done to solve this problem?

An argument in the 'MID' function has an incorrect data type or has an invalid value. (This tells me when I update data.)

[AlexisOlson · Accepted solution]

I don't recognize ONLY as a DAX function.

What are you expecting MonthName to look like? Why not just use FORMAT ( [Date], "mmmm" )?