Convert excel formula to DAX

[Courtb86]

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)

I am about 10 points off when I complete the DAX code.

[Uzi2019]

Hi @Courtb86 
You can share the sample input and expected output for better undertsating.

It seems you are taking a cell value of 28th row and 26th row. better if you can share input and output you want.

[adudani · Accepted solution]

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.

[Courtb86]

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)