Share via

Monthname in DAX in english?

  • Article

Question

Wednesday, September 23, 2015 11:15 AM

I am using the DAX formula:

=format(Month([Date]);"mmmm")

It gives me the full month name, but in my local language. I want the month name to always be in english. How do I achieve this?

All replies (2)

Wednesday, September 23, 2015 3:07 PM âś…Answered | 2 votes

A SWITCH() can be much easier to manage and much cleaner looking than a large nested IF() statement.

Something like this might work well for you:

=
SWITCH (
    MONTH ( [Date] ),
    1, "January",
    2, "February",
    3, "March",
    4, "April",
    5, "May",
    6, "June",
    7, "July",
    8, "August",
    9, "September",
    10, "October",
    11, "November",
    12, "December"
)

Wednesday, September 23, 2015 1:10 PM

Create a calculated column that is a big if statement. "IF([MonthName]="xyz","January",IF([MonthName]="zyx","February",...