Fix DAX FORMAT Returning the Wrong Month in Excel
Question details
The user needs DAX FORMAT to return the correct month name from a Service Date column.
- Product
- Microsoft Excel Power Pivot
- Device & OS
- not provided
- Scenario
- A DAX formula formats Service Date values as full month names in an Excel data model.
- Observed behavior
- FORMAT may return incorrect month names when the source date column contains text rather than date values.
Check a few Service Date values against the original source, especially dates that could be read as either day/month or month/day. Confirm that Power Pivot is available in Excel so you can inspect the data model.
Convert Service Date to a date before using DAX FORMAT
Use this approach when Service Date contains text or is interpreted with the wrong date order.
Open the source table in Excel or Access and compare several Service Date entries with the original records. Check whether ambiguous values use month/day/year or day/month/year.
In Excel, select the Service Date column and choose Data > Text to Columns. Choose Delimited, continue to the final screen, select Date with the correct source date order, and click Finish. Alternatively, convert the column to a Date/Time field in Access.
In Excel, choose Data > Refresh All, then open Power Pivot > Manage. Select the Service Date column and check that its data type is Date rather than Text.
In the Power Pivot window, add a calculated column and enter =FORMAT('Table'[Service Date], "MMMM"), replacing Table with your actual table name. Check the resulting month names against the source dates.

Review and format spreadsheet dates with WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and Microsoft Office format compatibility for an easier transition. Use WPS Spreadsheets to review and format date values; it does not fix Excel Power Pivot or DAX issues.

Frequently Asked Questions
Why does DAX FORMAT show the wrong month?
The Service Date column may contain text that was interpreted using the wrong date order. Check the source values, convert them to dates, and refresh the Excel data model.
Which DAX format returns the full month name?
In a Power Pivot calculated column, use =FORMAT('Table'[Service Date], "MMMM"), replacing Table with the name of your table.
How can I check the Service Date data type in Power Pivot?
In Excel, open Power Pivot > Manage, select the Service Date column, and check its data type. It should be a date type rather than Text.
Does changing the cell format convert text into dates?
No. If the values are text, use Data > Text to Columns and choose the correct source date order, then refresh the data model.




