Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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 |
|---|---|
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |
| User | Count |
|---|---|
| 24 | |
| 21 | |
| 13 | |
| 10 | |
| 8 |