Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys, my brain is melting trying to configure a large "x is greater than y, but less than z" statement with multiple parameters 😫 Could someone help get me started please?
What I'm trying to configure is:
if column A is less than or equal to 9.99, result 1,
if column A is greater than or equal to 10.00 but less than or equal to 19.99, result 2,
if column A is greater than or equal to 20.00 but less than or equal to 39.99, result 3 (and so on!)
Solved! Go to Solution.
You do not need the second parameter in the condition line, just use
if <10 then 1
if <20 then 2
if <40 then 3
else 4
Kudos and mark as solution appreciated.
Try to add a custom column
if [Column A] <= 9.99 then 1
else if [Column A] >= 10.00 and [Column A] <= 19.99 then 2
else if [Column A] >= 20.00 and [Column A] <= 39.99 then 3 else null
Thank you both!
Try to add a custom column
if [Column A] <= 9.99 then 1
else if [Column A] >= 10.00 and [Column A] <= 19.99 then 2
else if [Column A] >= 20.00 and [Column A] <= 39.99 then 3 else null
You do not need the second parameter in the condition line, just use
if <10 then 1
if <20 then 2
if <40 then 3
else 4
Kudos and mark as solution appreciated.