Need a help on multiple if condition statment

[Anonymous]

Hi Experts,

I need a help, I want to lookup the value from another sheet and check the conditions and calculate the values.

the below formula i have it in excel, how to convert it into DAX or measure in Power BI.

=IF(AND($C1870="STUSCO",$E1870<>1022,$E1870<>"XA04"),IF($B1870="Products",0,IF($B1870="Crude",$L1870,IFERROR($L1870*VLOOKUP($F1870,'STUSCO %'!$F$2:$K$200,5,0),$L1870/2))),0)\

Please help me, it's urgent

[Anonymous]

Seriously, how can we possibly help you in an issue like this? DAX is not a 1:1 translation with excel, it's a just a different model. How can we even think about finding a solution without an idea of the data structure?

IFERROR exists also in DAX
VLOOKUP can be generally achieved with a LOOKUPVALUE
IF has the same syntax in Excel and DAX

There is your help....