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
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
