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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

AvPowerBI , try like

format(MONTH ( [Date] ), "00")