The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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
User | Count |
---|---|
15 | |
13 | |
9 | |
6 | |
6 |
User | Count |
---|---|
27 | |
19 | |
13 | |
9 | |
5 |