keep leading zero of convert data

Hi YuanG; a solution for this:

WeekNumberFormat =
IF (
    LEN ( FORMAT ( Calendario[Date]; "yyyy-ww" ) ) = 6;
    MID ( FORMAT ( Calendario[Date]; "yyyy-ww" ); 1; 5 ) & "0"
        & MID ( FORMAT ( Calendario[Date]; "yyyy-ww" ); 6; 2 );
    FORMAT ( Calendario[Date]; "yyyy-ww" 
)

Sean I know I did it for year-and-month using FORMAT. As far as I can remember, the only example for year-and-week that you might be thinking of would be if you actually took the time to read through that crazy query code I use for my very slow standard date table. That has a custom column called WeekNumber, which is...

= Int64.From(
	Text.From(
		Date.Year(
			Date.EndOfWeek([Date])
		)
	)
	&
	Text.PadStart(
		Text.From(
			Date.WeekOfYear(
				Date.EndOfWeek([Date])
			)
		),
		2,
		"0"
	)
)

That formula returns an integer value without the hyphen in the middle. You should be able to modify it pretty easily to remove the integer conversion and add a hyphen character to the concatenation.

In DAX it's...

WeekNum = IF(
	WEEKNUM(DateTable[Date]) < 10, 
	YEAR(DateTable[Date]) & "-0" & WEEKNUM(DateTable[Date]),
	YEAR(DateTable[Date]) & "-" & WEEKNUM(DateTable[Date])
)