Forum Discussion
DAX calculation-IF/AND
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
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
1 Reply
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