How do I convert year and week number to a date in M language?

[PWillsNorgine]

Hi,

I have a year column and a week number column in my raw data (the values were provided by week) and in a seperate Power BI model I used DAX to create a date using Sunday as the last day of the week:

DATE([Year],1,1)-WEEKDAY(DATE([Year],1,1),2)+[Week No]*7

I need to now change the column from DAX to Power Query M language in order to append with other raw data queries that already have date columns.

Does anyone know what the M script is to do this?

Thanks

[Gordonlilj · Accepted solution]

Hi,

You could try the solution provided here

Re: convert week number into data