Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Aggro
Frequent Visitor

DAX Month Format Function

Hi

I want to format the month with two digits by using the FORMAT function, but the result wasn't expected. 

 

 

DAX:  FORMAT ( 1 , "MM")  

Result:  12

 

The result I expected should be  01

2 ACCEPTED SOLUTIONS
HobbyS
Regular Visitor

You have to put in a [Date] instead of 1. Example:

=FORMAT(DATEVALUE("30.11.2023");"MM")

You will get 11 for the month-Number.

View solution in original post

FreemanZ
Super User
Super User

hi @Aggro 

 

try like:

FORMAT(1, "00")

 

you get 12, because DAX take 1 as 1899/12/31, so it returns 12

 

View solution in original post

2 REPLIES 2
FreemanZ
Super User
Super User

hi @Aggro 

 

try like:

FORMAT(1, "00")

 

you get 12, because DAX take 1 as 1899/12/31, so it returns 12

 

HobbyS
Regular Visitor

You have to put in a [Date] instead of 1. Example:

=FORMAT(DATEVALUE("30.11.2023");"MM")

You will get 11 for the month-Number.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.