Forum Discussion
Como calcular un Roling 12
hola:
Quisiera que me ayudaran a calcular un roling 12 para la venta, si tengo diferentes plantas y diferentes plataformas. En la tabla de abajo tengo un ejemplo y quisera sumar la venta de Febrero 2017 a Enero 2018 por planta y plataforma ....
| Año | Mes | Planta | Plataforma | Ventas | Año | Mes | Planta | Plataforma | Ventas | |
| 2017 | Ene | A | XY | 200 | 2017 | Ene | B | TR | 300 | |
| 2017 | Feb | A | XY | 400 | 2017 | Feb | B | TR | 200 | |
| 2017 | Mar | A | XY | 600 | 2017 | Mar | B | TR | 600 | |
| 2017 | Abr | A | XY | 1000 | 2017 | Abr | B | TR | 900 | |
| 2017 | May | A | XY | 500 | 2017 | May | B | TR | 400 | |
| 2017 | Jun | A | XY | 800 | 2017 | Jun | B | TR | 900 | |
| 2018 | Ene | A | XY | 100 | 2018 | Ene | B | TR | 900 | |
| 2018 | Feb | A | XY | 500 | 2018 | Feb | B | TR | 800 | |
| 2018 | Mar | A | XY | 600 | 2018 | Mar | B | TR | 300 | |
| 2018 | Abr | A | XY | 900 | 2018 | Abr | B | TR | 900 | |
| 2018 | May | A | XY | 400 | 2018 | May | B | TR | 250 | |
| 2018 | Jun | A | XY | 700 | 2018 | Jun | B | TR | 900 | |
| 2017 | Ene | A | WE | 100 | 2017 | Ene | B | PL | 250 | |
| 2017 | Feb | A | WE | 350 | 2017 | Feb | B | PL | 600 | |
| 2017 | Mar | A | WE | 700 | 2017 | Mar | B | PL | 400 | |
| 2017 | Abr | A | WE | 900 | 2017 | Abr | B | PL | 900 | |
| 2017 | May | A | WE | 1100 | 2017 | May | B | PL | 800 | |
| 2017 | Jun | A | WE | 400 | 2017 | Jun | B | PL | 300 | |
| 2018 | Ene | A | WE | 100 | 2018 | Ene | B | PL | 250 | |
| 2018 | Feb | A | WE | 350 | 2018 | Feb | B | PL | 800 | |
| 2018 | Mar | A | WE | 700 | 2018 | Mar | B | PL | 300 | |
| 2018 | Abr | A | WE | 900 | 2018 | Abr | B | PL | 600 | |
| 2018 | May | A | WE | 1100 | 2018 | May | B | PL | 400 | |
| 2018 | Jun | A | WE | 400 | 2018 | Jun | B | PL | 300 |
Agradezco mucho su apoyo y sus comentarios
Saludos
1 Reply
Hi Ely
You may add a data column for your data first. Then you may refer to below measure. Here is the article for you.
https://www.sqlbi.com/articles/rolling-12-months-average-in-dax/
Measure = CALCULATE ( SUM ( Data[Ventas] ), DATESBETWEEN ( Data[Date], NEXTDAY ( SAMEPERIODLASTYEAR ( Data[Date] ) ), LASTDATE ( Data[Date] ) ) )Regards,
Cherie
