This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
The data I'm trying to join has week number such as 201501, 201502, and so on. My other data source has separate year and week columns so I create a formula (ToNumber(ToString([Year],0) + ToString([Week],0))) to make it the same format as the other data source.
And here's my question:
Data Source 1 week number format:
Data Source 2 week number format (The one I combined year and week columns)
Is there any ways to make 1 digit week number to 2 digits week number so I can join them togehter?