Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
GemPOWER
Frequent Visitor

VAR HELP

Hola,
necesito crear tres variables (p2a,p2b y p5), 
¿ cómo podría poner está super fórmula de manera correcta ? Gracias

 

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)

1 REPLY 1
AlB
Community Champion
Community Champion

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  Datanaut

 

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.