Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need Help to Convent Excel Formula into Power Bi

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.
 
 
 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.