Function Problems

Fix DAX FORMAT Returning the Wrong Month in Excel

Natalie TaylorNatalie Taylor Nov 14, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Inspect the source dates

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.

2
Convert text dates

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.

3
Refresh and check the model

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.

4
Format the month

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.

Convert Service Date to a date before using DAX FORMAT
Check the date order: Formatting a text cell as a date does not necessarily convert it to a date value. If a source date is ambiguous, select the correct date order during conversion before refreshing the model.
Free Microsoft Office alternative

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.

Review and format date columns in a familiar spreadsheet interfaceOpen and edit Microsoft Excel XLS and XLSX filesWork with a free, lightweight office suite
QA img-9

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.