Forum Discussion
Convert excel formula to DAX
Hi,
When I convert an excel formula to a DAX Code, it does not give me the correct % and I cannot figure out why. See below
Excel Formula: =((C28*40+E28*40+G28*10+I28*10))+(K26+M26+O26)
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.
3 Replies
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)
