I want to format the month with two digits by using the FORMAT function, but the result wasn't expected.
DAX: FORMAT ( 1 , "MM")
The result I expected should be 01
Go to Solution.
You have to put in a [Date] instead of 1. Example:
You will get 11 for the month-Number.
View solution in original post
you get 12, because DAX take 1 as 1899/12/31, so it returns 12
Find out more about the May 2023 update.
Share your Data Story with the Community in the Data Stories Gallery.