topic DAX Month Format Function in DAX Commands and Tips

DAX Month Format Function

Aggro — Wed, 22 Feb 2023 18:58:59 GMT

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

HobbyS — Wed, 22 Feb 2023 20:09:15 GMT

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.

FreemanZ — Thu, 23 Feb 2023 02:04:35 GMT

try like:

FORMAT(1, "00")

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