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.
Hi all,
I'm trying to create a custom column but I can't seem to get the formula right. I get the message literal value expected.
Any idea where I'm going wrong?
if ([Column] >= 6.1 && [Column] <= 7.0) then “Value1" else if [Column] >= 4.78 and [Column] <= 4.99 then “Value2” else if [Column] >= 3.21 and [Column] <= 3.5 then “Value3” else if [Column] >= 1.4 and [Column] <= 3.20 then “Value4” else “”
Solved! Go to Solution.
Got it working. Think it was a case of quotes in the wrong places
if [Column]>= 6.1 and [Column] <=7.0 then "Value1" else if [Column] >= 4.78 and [Column] <= 4.99
then "Value2"
else if [Column] >= 3.21 and [Column]<= 3.5
then "Value3"
else if [Column]>= 1.4 and [Column] <= 3.20
then "Value4"
else null
Hi,
Try using and instead of &&
Hi
I tried it with And instead of && but it was tagging the error as being just before the 1st then
Got it working. Think it was a case of quotes in the wrong places
if [Column]>= 6.1 and [Column] <=7.0 then "Value1" else if [Column] >= 4.78 and [Column] <= 4.99
then "Value2"
else if [Column] >= 3.21 and [Column]<= 3.5
then "Value3"
else if [Column]>= 1.4 and [Column] <= 3.20
then "Value4"
else null
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.
User | Count |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |