Excel formula to Power BI Calculated Column

RYNHARD1 — Mon, 04 Dec 2023 08:49:09 GMT

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

Re: Excel formula to Power BI Calculated Column

Fowmy — Mon, 04 Dec 2023 09:06:57 GMT

RYNHARD1
Upload your data in power BI and share the PBIX file expalining the desired results
Use Google Drive to save your file and share the link here.

topic Excel formula to Power BI Calculated Column in DAX Commands and Tips

Excel formula to Power BI Calculated Column

Re: Excel formula to Power BI Calculated Column