Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.