Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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
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
User | Count |
---|---|
99 | |
87 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |