Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!View all the Fabric Data Days sessions on demand. View schedule
Var P2a= IF(Oportunidad[Fecha_Adjudicacion__c]=YEAR(NOW()-1;
SI Oportunidad[Duracion_Contrato_Base_meses__c]>12<24month = (Presupuesto[PVP_Anual__c]-Presupuesto[PVP_Total_Anios__c]
SI Oportunidad[Duracion_Contrato_Base_meses__c] <12 month=0)
Var P2b= IF(Oportunidad[Fecha_Adjudicacion__c]=YEAR(NOW();
Si Presupuesto[Duracion_del_Contrato_base__c] < 12 meses dame Presupuesto[PVP_Total_Anios__c]
Si Presupuesto[Duracion_del_Contrato_base__c] >12 meses dame Presupuesto[PVP_Anual__c]
Var P5= IF(Oportunidad[Fecha_Adjudicacion__c]=YEAR(NOW() dame el (Presupuesto[PVP_Total_Anios__c];0)
Return;
sum(varP2a+VarP2b+P5)
Hi @GemPOWER
Assuming the definition of the variables is correct as shown, you can do something like:
measure =
VAR P2a = Definition as you have it
VAR P2b = Definition as you have it
VAR P5 = Definition as you have it
RETURN
P2a + P2b + P5
Please mark the question solved when done and consider giving kudos if posts are helpful.
Cheers ![]()
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 17 | |
| 11 | |
| 9 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 31 | |
| 25 | |
| 21 | |
| 14 | |
| 12 |