Obtener fecha de cada lunes, sabiendo nº de semana y año

[JUAN_1969]

Muy buenas.

Tengo una tabla que me viene con el numero de la semana iso y el año, y necesito con estos dos datos obtener la fecha que le corresponde a cada lunes.

Necesito crearlo en el editor de power query desde power bi.

Gracias por vuestra ayuda.

[v-cgao-msft · Accepted solution]

Hi @JUAN_1969 ,

You might consider creating a new date table and filtering out the Monday dates, like this.

Then merge queries.

Add custom columns to complete the missing dates at the beginning and end of the year.

= if [Column1] = null then try Date.AddDays(Table.SelectRows(#"Expanded Query1",(x)=>[Year]=x[Year] and [Week]+1=x[Week])[Column1]{0},-7) otherwise Date.AddDays(Table.SelectRows(#"Expanded Query1",(x)=>[Year]=x[Year] and [Week]-1=x[Week])[Column1]{0},7) else [Column1]

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum