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.

[sam8]

This is a great question. I've reproduced the problem on my end, so I agree something weird is going on. I'm going to submit a bug to our engineering team; I'll let you know if there are any updates! (For reference, the tracking number is 387508094.)