DAX calculation-IF/AND

[g-wizard]

Hello,

I am having difficulties converting this calc from tablau to Dax. Any help would be appreciative.

if [Cost of Sales]>=1000 AND [Open Order Value] =0 THEN 'GA'
ELSEIF [Cost of Sales]>=1000 AND [Cost of Sales]>=0.7*[Open Order Value]
AND [Open Order Value]>0 THEN 'LL' ELSE 'NA' END

[bhanu_gautam · Accepted solution]

@g-wizard , Try using below method

= IF(
[Cost of Sales] >= 1000 && [Open Order Value] = 0, "GA",
IF(
[Cost of Sales] >= 1000 && [Cost of Sales] >= 0.7 * [Open Order Value] && [Open Order Value] > 0, "LL",
"NA"
)
)

Please accept as solution and give kudos if it helps