Forum Discussion
Solved
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]>=...
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
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