Forum Discussion
Solved
Year number issue
Good morning,
Can anyone assist me in this issue.
Would like a work around in the year coloumn, if week num 52 happens to be in January, thena year should be for prevouis year.
Example as per image, the year for week 52 should read 2021 not 2021.
Hope I explianed myself well & thanks in advance.
brinky , Based on what I got you can create year of week
week Year = Year('Date'[Date]+-1*WEEKDAY('Date'[Date])+1)
2 Replies
brinky , Based on what I got you can create year of week
week Year = Year('Date'[Date]+-1*WEEKDAY('Date'[Date])+1)
