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,
Can someone please look over my IF statment below which is bringing back this error message Token Eof expected with the error showing on the first row.
=IF[Age] <= 20 THEN "Upto 20yrs"
ELSE IF [Age] >= 21 AND [Age] <= 30 THEN "21-30yrs"
ELSE IF [Age] >= 31 AND [Age] <= 40 THEN "31-40yrs"
ELSE IF [Age] >= 41 AND [Age] <= 50 THEN "41-50yrs"
ELSE "Over 50yrs"
Many Thanks
Solved! Go to Solution.
Hi All,
solved it myself as below.
if[Age] <= 20 then "Upto 20yrs"
else if [Age] >= 21 and [Age] <= 30 then "21-30yrs"
else if [Age] >= 31 and [Age] <= 40 then "31-40yrs"
else if [Age] >= 41 and [Age] <= 50 then "41-50yrs"
else "Over 50yrs"
Hi All,
solved it myself as below.
if[Age] <= 20 then "Upto 20yrs"
else if [Age] >= 21 and [Age] <= 30 then "21-30yrs"
else if [Age] >= 31 and [Age] <= 40 then "31-40yrs"
else if [Age] >= 41 and [Age] <= 50 then "41-50yrs"
else "Over 50yrs"
Hi,
Try this one
= if [Age] <= 20 then "Upto 20yrs"
else if [Age] <= 30 then "21-30yrs"
else if [Age] <= 40 then "31-40yrs"
else if [Age] <= 50 then "41-50yrs"
else "Over 50yrs"
If this post is useful to help you to solve your issue consider giving the post a thumbs up
and accepting it as a solution !
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 |
---|---|
107 | |
105 | |
88 | |
74 | |
66 |
User | Count |
---|---|
126 | |
111 | |
100 | |
83 | |
71 |