Forum Discussion

AvPowerBI's avatar
AvPowerBI
Icon for Post Patron rankPost Patron
4 years ago
Solved

Include 0 for month number where applicable

Hi,   I currently have the below calendar.   Dates = VAR MinYear = YEAR ( MIN ('Fact'[Employment Start Date] ) ) VAR MaxYear = YEAR ( MAX ('Fact'[Employment End Date] ) ) RETURN ...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

Hi, AvPowerBI 

 

You can check the following methods.

Month = FORMAT(MONTH(Dates[Date]),"00")
Start of Month = "01-"&[Month]&"-"&[Year]

More information about time and date formats can be found in the following links.

https://docs.microsoft.com/dax/format-function-dax 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.