Forum Discussion
Solved
Weeks are numbered from 1 to 145
Need help please i am working on a dataset and I don't have any dates columns except a week column that starts from 1 to 145. I am interested in converting this column to week numbers from 1 to 52 ...
You can add a column which uses Number.Mod (https://learn.microsoft.com/en-us/powerquery-m/number-mod ) to divide the week column by 52. That will work great for all values except the multiples of 52 which will show as zero.
So you can add another column which says 'if my newvalue is 0 then 52 else newvalue'
--
If you're confident with the code you could combine both steps in the first column
jgordon11
Resolver II
Resolver IIAn example:
let
Source = #table(type table [WeekNum = Int64.Type], List.Zip({{1 .. 145}})),
tbl = Table.TransformColumns(Source, {"WeekNum", each Number.Mod(_ - 1, 52) + 1})
in
tbl