Need Help to Convent Excel Formula into Power Bi

[Anonymous]

Hi Everyone.

I have excel file Link: https://1drv.ms/x/s!Ag7FsQb8nMXMhAjAKTxdJv0HhfEK?e=W93LVi

which I have to convent into the bi file.

Excel Version Formula: IF(J7>=AF7,((AF7*B7)-(J7*B7))*SUMIFS(Averages!U:U,Averages!A:A,Main!A7),0)*-1

Bi Version Formula (which I try to convent But the result are not the same) = 

UD Voice : IF([Voice Conv]>=[Voice Conv Rate],0,([Voice Conv Rate]*[Traffic trend])-([Voice Conv]*[Traffic trend])*[TM Avg Voice])

I have shared the files please help me out.

[Anonymous]

Without the Power BI file it is hard to help. Did you include *-1 in your Power BI formula? I don't see it. 

[Anonymous]

@Anonymous  *-1 for just negative Value. , All calculation is possible from excel file

---

@Anonymous wrote:

Without the Power BI file it is hard to help. Did you include *-1 in your Power BI formula? I don't see it. 

---