Forum Discussion
Solved
Week error because of year change
Hello, Could anyone consult me what would be the right way to display the chart in this situation: I'm trying to display data weekly and because of that, there is some missunderstandings in year ch...
Hi DomantasK ,
Modify the [Year] column like below:
Year = IF('Table'[Week] = 52, 2021, YEAR('Table'[Date]))The chart is normal:
Best regards,
Yadong Fang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you! 🙂