Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

MID function to know which month it corresponds to

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 corresp...
  • AlexisOlson's avatar
    AlexisOlson
    2 years ago

    I don't recognize ONLY as a DAX function.

     

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

AlexisOlson's avatar
AlexisOlson
Icon for Super User rankSuper User
2 years ago

I don't recognize ONLY as a DAX function.

 

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