Forum Discussion
Weekly Target Calculation Dax
Good day, I need help to create a dax measure, I have a monthly sales goal per executive, what I need to the extent is that to that monthly goal depending on the week of the month in which we are tha...
Good afternoon, I attach tables to specify information:
Tablo_Objetivos
| IDVENDEDOR | PERIOD | CAPITAL | OPERATIONS |
| 7 | 01/10/2023 | 5270747 | 72 |
| 33 | 01/10/2023 | 3963988 | 40 |
| 37 | 01/10/2023 | 3394703 | 35 |
| 9 | 01/10/2023 | 12137404 | 160 |
| 5 | 01/10/2023 | 18302477 | 190 |
| 6 | 01/10/2023 | 3596126 | 110 |
| 10 | 01/10/2023 | 9329384 | 85 |
| 82 | 01/10/2023 | 5084960 | 65 |
| 20 | 01/10/2023 | 9007089 | 90 |
| 11 | 01/10/2023 | 8615403 | 100 |
Tabla_Ejecutivos
| IDVENDEDOR | SELLER |
| 5 | EJECUTIVO_1 |
| 6 | EJECUTIVO_2 |
| 7 | EJECUTIVO_3 |
| 9 | EJECUTIVO_4 |
| 10 | EJECUTIVO_5 |
| 11 | EJECUTIVO_6 |
| 20 | EJECUTIVO_7 |
| 33 | EJECUTIVO_9 |
| 37 | EJECUTIVO_10 |
| 82 | EJECUTIVO_11 |
Tabla_Ventas
| fechaalta | CapitalPedido | CodEjecutivo |
| 09/10/2023 | $ 3.180,00 | 6 |
| 09/10/2023 | $ 21.200,01 | 6 |
| 09/10/2023 | $ 274.911,82 | 5 |
| 07/10/2023 | $ 105.839,99 | 82 |
| 07/10/2023 | $ 75.599,99 | 5 |
| 06/10/2023 | $ 5.400,00 | 5 |
| 06/10/2023 | $ 118.799,99 | 9 |
| 06/10/2023 | $ 171.570,00 | 7 |
| 05/10/2023 | $ 97.199,99 | 37 |
| 05/10/2023 | $ 75.599,99 | 33 |
| 05/10/2023 | $ 41.040,00 | 10 |
| 04/10/2023 | $ 21.200,01 | 6 |
| 04/10/2023 | $ 24.168,01 | 11 |
| 03/10/2023 | $ 323.999,97 | 20 |
| 03/10/2023 | $ 47.520,00 | 10 |
| 02/10/2023 | $ 64.799,99 | 82 |
| 02/10/2023 | $ 53.000,01 | 5 |
| 02/10/2023 | $ 107.999,99 | 33 |
Please indicate what you mean by "week". Ideally your data model should have a Calendar table that clearly indicates week numbers, especially if you are attempting to project weeks onto months.