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