Forum Discussion
Courtb86
2 years agoFrequent Visitor
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) ...
- 2 years ago
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.