Excel WEEKNUM equivalent Power Query M Function

[Skip2MiLu]

Hi Guys


Does anyone know if there is any M function for Power Query to return the equivalent Weeknum function as used in Excel (see below) that I can use to in a custom column expression in power query to return the week number of a corresponding date column.

You will notice that I would like the Power Query expression to use the the equivalent 22 return type in excel Weeknum, which I not sure is possible.
I have browsed Microsoft Power Query M Function list below and did not seem to find anything, but not sure if I missing something

DateTime functions - PowerQuery M

Learn more about: DateTime functions

docs.microsoft.com

 

[denzo36]

Add a custom column and use the below function - [Column1] in the formula below contains the column in which the date number is stored

= Date.WeekOfYear([Column1],Day.Monday)

 

[Skip2MiLu]

Thanks I do not know how I missed that.
Do you know if there is a way to work backwards.
I. E. Is there a function to calculate the date of the Monday or Friday if I had a columns with a week number and year?

 

[Skip2MiLu]

Add a custom column and use the below function - [Column1] in the formula below contains the column in which the date number is stored

= Date.WeekOfYear([Column1],Day.Monday)

Thanks for the function. But I have noticed that this function is not taking calculating the ISO week number as the excel expression I mentioned WEEKNUM (Date,21)