Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |