Excel formula to Power BI Calculated Column

Good day everyone, I am struggling with translating the following formula to PowerBI.
=IF(OR(G6="L",G6="L - AFA"),0,
IF(OR(G6="CFI",G6="CFI - AFA"),
IF(SUM(SUMIFS(H:H,D:D,D6,G:G,{"NB";"NB - AFA"}))+H6>0,0,
IF(SUM(SUMIFS(H:H,D:D,D6,G:G,{"NB";"NB - AFA"}))+H6=0,

IF(OR(I6/F6*100<=IF(VALUE(LEFT(D6,3))=871,-30000,-40000),INT(J6/F6*100)<0),-1,0),-1)),
IF(H6<=0,0,
IF(OR(G6="NB - AFA",G6="NB"),IF(OR(I6/F6*100>=IF(VALUE(LEFT(D6,3))=871,30000,40000),INT(J6/F6*100)>0),1,0),
IF(OR(J6/F6*100>=3599.5,I6/F6*100>=IF(VALUE(LEFT(D6,3))=871,30000,40000)),1,0)))))
*IF(F6<100,IF(AND(LEFT(A6,4)="DFCR",F6=60),1,0.5),1)

PS: D6 in the formula is cell specific and needs to calculate accordingly in the Calculated Column