Format the week number in your Power Pivot date table
When creating your date table in Power Pivot the users typically want a Week label containing the week number and the year – 2014 and week 14
If you create a calculated column in your table and use the format code ” 00″ in the TEXT function second parameter
You can do the same in Power Pivot by adding a calculated column
But in Power Pivot you have to use the FORMAT function instead of the TEXT function.