Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Need a help on multiple if condition statment

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

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

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