Forum Discussion
Convert excel formula to DAX
hi Courtb86 ,
Kindly provide a sample input and output, masking any sensitive data.
If you are off, it's probably due to Order of Operations. I would recommend adding parenthesis to double check this :
( (C28*40)+ (E28*40)+ (G28*10)+ (I28*10) )+ (K26+M26+O26)With the sample input, I will be able to provide the relevant dax formula.
hi Courtb86 ,
Kindly provide a sample input and output, masking any sensitive data.
If you are off, it's probably due to Order of Operations. I would recommend adding parenthesis to double check this :
(
(C28*40)+
(E28*40)+
(G28*10)+
(I28*10)
)+
(K26+M26+O26)
With the sample input, I will be able to provide the relevant dax formula.
FINAL= if(((([Measure 1]*10)+
([Measure 2]*40)+
([Measure 3]*10)+
([Measure 4]*40))-
[Measure 5]-
([Measure 6])-
([Measure 7]*5))/100<0,0,
((([Measure 1]*10)+
([Measure 2]*40)+
([Measure 3]*10)+
([Measure 4]*40))-
([Measure 5])-
([Measure 6])-
([Measure 7])*5)/100)