How to convert text to iso year week? | Google Looker Studio

[gobiu]

I encountered an issue while using Looker Studio. I have a column of Text(YYYY-WW) from google sheet that I need to convert into the ISO Year Week date format. However, after applying the formula PARSE_DATE('%Y-%V', WK), every entry returns the same result(1 Jan 2024 to 7 Jan 2024 (Week 1)). I'm unsure how to resolve this.