Calculate number of weeks in a year

[crln-blue]

Hello!

Not sure where to post this but here it goes.

I'm creating a custom column in power query where I need to make a list of numbers. My start number is 1 but my end number varies, which is dependent on the number of weeks in a current year.

Here is my code:

What I would like to be is 

=List.Numbers(1, (# of weeks in current year: year(now))

How do I compute this? Thanks for the help!

[CNENFRNL · Accepted solution]

Hi, @crln-blue , you might want to use this code

= {1..Date.WeekOfYear(DateTime.LocalNow())}

[crln-blue]

Hello @CNENFRNL ! Thanks for this!