Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
25 | |
20 | |
18 | |
18 | |
17 |
User | Count |
---|---|
36 | |
22 | |
19 | |
18 | |
11 |