Forum Discussion
Helper IComapara Seamanas
Hola, tengo una situacion en la cual necesito compara las semanas del a'o, pero no se que formula deberia utilizar, la situacion es la siguiente:
para el a'o 2022 la semana 1 de a'o seria del 3 al 9 de enero, (conciderando que la semana es de lunes a domingo) y quiero comparar la semana 1 del 2023 que en este caso seria del 2 al 8 de enero, el problema es crear una columna de semanas en la tabla calendario la semana 1 se reinica al comenzar en nuevo a;o por lo que si comparo la semana 1 del 2022 con la semana 1 del 2023 solo estaria considerando el 1/01/23, existe alguna formula que pueda utilizar para que al llegar a la ultima semana del 2022 contemple el la semana completa aunqe sea parte del siguiente a;o?
Saludos
cecitorresHF , You can create a measure 364 behind or ahead
week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
At week level
This Week= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Week] = Max('Date'[Week]) ))
Last Year Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Week] = Max('Date'[Week])))Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510
1 Reply
- amitchandak
Super User
cecitorresHF , You can create a measure 364 behind or ahead
week Year behind Sales = CALCULATE(SUM(Sales[Sales Amount]),dateadd('Date'[Date],-364,DAY))
At week level
This Week= CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year]) && 'Date'[Week] = Max('Date'[Week]) ))
Last Year Week = CALCULATE(sum('Table'[Qty]), FILTER(ALL('Date'),'Date'[Year]=max('Date'[Year])-1 && 'Date'[Week] = Max('Date'[Week])))Power BI — Week on Week and WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-Last-Week/ba-p/1051123
https://www.youtube.com/watch?v=pnAesWxYgJ8
Time Intelligence, Part of learn Power BI https://youtu.be/cN8AO3_vmlY?t=27510