Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Estimados, necesito ayuda en encontrar la solucion a mi problematica,
Tengo 2 tablas
Ventas
Fecha | CodProd | CantFacturada | PreUniMB | PreCosto |
11/05/2023 | A42051150 | 25 | 651 | ? |
11/05/2023 | R37100102 | 2 | 24,194 | ? |
11/05/2023 | A42051150 | 6 | 651 | ? |
11/05/2023 | A42051200 | 5 | 651 | ? |
12/05/2023 | A42051150 | 103 | 481 | ? |
15/05/2023 | A42051200 | 40 | 560 | ? |
15/05/2023 | A42051150 | 300 | 567 | ? |
22/05/2023 | A42051400 | 10 | 1,031 | ? |
22/05/2023 | A42051300 | 17 | 1,022 | ? |
22/05/2023 | A42051350 | 81 | 1,022 | ? |
25/05/2023 | A42051150 | 3 | 651 | ? |
25/05/2023 | A83050010 | 1 | 3,814 | ? |
29/05/2023 | A70058720 | 1 | 38 | ? |
31/05/2023 | R37100102 | 1 | 24,194 | ? |
01/06/2023 | R40101052 | 1 | 1,109 | ? |
02/06/2023 | A70058100 | 1 | 1,429 | ? |
02/06/2023 | A83050010 | 10 | 3,814 | ? |
06/06/2023 | A70058100 | 2 | 1,429 | ? |
06/06/2023 | A83050010 | 15 | 3,814 | ? |
07/06/2023 | R40101052 | 1 | 1,244 | ? |
07/06/2023 | R30100200 | 2 | 9,313 | ? |
08/06/2023 | R40101052 | 2 | 1,244 | ? |
09/06/2023 | R40101052 | 5 | 1,244 | ? |
09/06/2023 | A70058100 | 30 | 1,429 | ? |
12/06/2023 | A83050010 | 10 | 3,433 | ? |
12/06/2023 | A83050010 | 10 | 3,433 | ? |
14/06/2023 | A83050010 | 77 | 3,814 | ? |
19/06/2023 | A83050010 | 15 | 3,814 | ? |
19/06/2023 | A83050010 | 1 | 3,814 | ? |
19/06/2023 | R37100102 | 6 | 21,558 | ? |
20/06/2023 | A83050010 | 10 | 3,433 | ? |
23/06/2023 | A42051200 | 6 | 651 | ? |
23/06/2023 | R40101052 | 1 | 1,244 | ? |
Compras
CodProd | Fecha | CantIngresada | PreUniMB |
A42051150 | 31/05/2023 | 50 | 508 |
A42051150 | 09/05/2023 | 50 | 432 |
A42051150 | 08/06/2023 | 50 | 508 |
A42051150 | 09/05/2023 | 150 | 432 |
A42051150 | 08/05/2023 | 250 | 508 |
A42051200 | 08/05/2023 | 50 | 508 |
A42051200 | 09/05/2023 | 50 | 432 |
A42051200 | 16/06/2023 | 50 | 508 |
A42051200 | 09/05/2023 | 50 | 432 |
A42051200 | 26/05/2023 | 50 | 432 |
A42051200 | 02/06/2023 | 50 | 432 |
A42051350 | 31/05/2023 | 50 | 763 |
A42051450 | 18/05/2023 | 300 | 653 |
A83050010 | 25/05/2023 | 400 | 1975 |
A83050010 | 26/05/2023 | 140 | 1975 |
A83050010 | 08/06/2023 | 195 | 1783 |
A83050010 | 18/05/2023 | 975 | 1766 |
R37100102 | 22/06/2023 | 10 | 7,308 |
R37100102 | 08/06/2023 | 10 | 7,308 |
R37100102 | 15/06/2023 | 10 | 7,308 |
R40101052 | 29/05/2023 | 400 | 882 |
Necesito crear una medida o columna que en la tabla de ventas me asocie el valor PreUniMB de la tabla compra, mas cercano o menor a la fecha de la tabla Ventas. Ejemplo
Fecha | CodProd | CantFacturada | PreUniMB | PreCosto |
11/05/2023 | A42051150 | 25 | 651 | 432 |
11/05/2023 | R37100102 | 2 | 24,194 | 8120 |
11/05/2023 | A42051150 | 6 | 651 | 432 |
11/05/2023 | A42051200 | 5 | 651 | 485 |
12/05/2023 | A42051150 | 103 | 481 | 432 |
15/05/2023 | A42051200 | 40 | 560 | 485 |
22/05/2023 | A42051300 | 17 | 1,022 | 748 |
22/05/2023 | A42051350 | 81 | 1,022 | 745 |
25/05/2023 | A83050010 | 1 | 3,814 | 1975 |
29/05/2023 | A70058720 | 1 | 38 | ? |
31/05/2023 | R37100102 | 1 | 24,194 | ? |
01/06/2023 | R40101052 | 1 | 1,109 | ? |
02/06/2023 | A70058100 | 1 | 1,429 | ? |
Help
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
2 | |
2 | |
2 | |
2 | |
1 |