Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
Proud to be a Super User!
@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
Proud to be a Super User!
User | Count |
---|---|
98 | |
89 | |
82 | |
70 | |
67 |
User | Count |
---|---|
115 | |
104 | |
101 | |
72 | |
64 |