Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hola comunidad!
Necesito calcular el incentivo por venta y cobranza de agencias de ventas.
Cada agencia se encuentra en un rango de objetivo por venta y otro objetivo por cobranza.
En caso de no cumplir con alguno de estos dos objetivos NO COBRA INCENTIVO.
Adjunto las tablas:
TABLA_FACT_VENTAS
ID_Agente | Venta_Mensual | %_Cobranza |
54000 | 18 | 70 |
74000 | 72 | 81 |
120000 | 71 | 58 |
131000 | 19 | 58 |
174000 | 16 | 84 |
200000 | 95 | 78 |
221000 | 78 | 59 |
275000 | 35 | 61 |
348000 | 14 | 60 |
415000 | 132 | 61 |
TABLA_DIM_AGENTES
ID_Agente | Nombre_Agente | ID_Grupo_Objetivos |
54000 | Almeyda Lorenzo | 1 |
74000 | Colucci Mariano | 2 |
120000 | Almada Martina | 2 |
131000 | Abel Zapatero | 1 |
174000 | Ceschi Juan Atilio | 1 |
200000 | Del Pino Hugo | 3 |
221000 | Bottinelli Diego | 2 |
275000 | Alejandra Cacheuta | 2 |
348000 | Daniela Ferrari | 1 |
415000 | Carlos Ruppen | 3 |
TABLA_DIM_INCENTIVOS
ID_Grupo_Objetivos | Incentivo_1 | Incentivo_2 |
1 | 1000 | 1500 |
2 | 1300 | 2000 |
3 | 2000 | 3000 |
TABLA_DIM_OBJETIVO_MENSUAL (Venta y cobranza)
ID_Agente | Objetivo_Venta | Objetivo_Cobranza |
54000 | 25 | 60 |
74000 | 50 | 60 |
120000 | 70 | 60 |
131000 | 20 | 60 |
174000 | 15 | 60 |
200000 | 100 | 60 |
221000 | 65 | 60 |
275000 | 40 | 60 |
348000 | 10 | 60 |
415000 | 120 | 60 |
Valoraré su ayuda en la resolución del caso.
Gracias!
Hi @GuilleLus ,
I'm sorry, I'm still not quite sure about what you want. You've given me the details, can you tell me what you want the result to be? What does Incentivo_1 - Tabla_DIM_Incentivos mean?
How to Get Your Question Answered Quickly - Microsoft Fabric Community
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi! Team _ Rongtie,
Thanks for your anser.
"Incentivo_1" and "Incentivo_2" are a economic rewards for the sellers.
Thank you again.
Best regard, Guillermo.-
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
104 | |
93 | |
83 | |
64 |