The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Tengo las siguientes tablas. Hay mas tablas con el detalle de los articulos pero creo que estas son las mas importante.
TABLA FORMULA MATERIAL | |||||||
CodigoMaterial | Formula | CodigoFormulaMaterial | CodigoInsumoMaterial | CodigoFormulaInsumoMaterial | CantidadInsumoMaterial | DescripcionMaterial | DescripcionInsumoMaterial |
A | No | Null | Null | Null | Material A | Null | |
B | Yes | 1 | A | Null | 2 | Material B | Material A |
C | Yes | 2 | A | Null | 0,5 | Material C | Material A |
C | Yes | 2 | B | 1 | 2 | Material C | Material B |
F | Yes | 3 | B | 1 | 3 | Material F | Material B |
F | Yes | 3 | C | 2 | 4 | Material F | Material C |
TABLA PRECIOS MATERIAL | |
CodigoMaterial | Precio |
A | $ 10,00 |
Necesito saber como rearmar la tabla que tenga la lista de materiales con una jerarquia que me permita volcar en una matriz un reporte como el que sigue a continuacion de ejemplo:
Nivel 1 | Nivel 2 | Nivel 3 | Nivel 4 | Cantidad | Cantidad*Precio |
Material C | $ 45,00 | ||||
Material A | 0,5 | $ 5,00 | |||
Material B | 2 | $ 40,00 | |||
Material A | 4 | $ 40,00 | |||
Material F | $ 200,00 | ||||
Material B | 3 | $ 60,00 | |||
Material A | 6 | $ 60,00 | |||
Material C | 4 | $ 140,00 | |||
Material A | 2 | $ 20,00 | |||
Material B | 6 | $ 60,00 | |||
Material A | 6 | $ 60,00 |
Desde ya, muchas gracias!
@v-jingzhan-msft
Quizas tu sepas como hacerlo en base tu ayuda en mi publicacion anterior.
The usual approach in such a scenario is to create shadow materials, specifically Material A1 and A2. A1 is a child of B and A2 is a child of C.
Same for B - B1 is a child of F and B2 is a child of C.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
34 | |
19 | |
18 | |
16 | |
13 |