Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
sks2701
Helper III
Helper III

token then expected

Hi- Can someone please help me what wrong I'm doing with the formula to get the error?

 

=if [Net sales growth] < 1% then "0% or below" else if [Net sales growth] >= 1% then "1% - 25%" else if [Net sales growth] >= 26% then "26% - 50%" else if [Net sales growth] >= 51% then "51% - 100%" else if [Net sales growth] >= 101% then "101% - 200%" else if [Net sales growth] >= 201% then "201% - 300%" else if [Net sales growth] >= 301% then "301% - 500%" else if [Net sales growth] >= 501% then "501% - 700%" else if [Net sales growth] >= 701% then "701% - 1000%" else if [Net sales growth] > 1000% then "Over 1000%" else "N/A"

 

sks2701_0-1603832063079.png

 

2 ACCEPTED SOLUTIONS
AlB
Super User
Super User

Hi @sks2701 

It must be the % character. You can't use it like that. Instead of 1% use the number: 1/100 or  0.01. Same for all other % instances in the code

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

View solution in original post

PhilipTreacy
Super User
Super User

Hi @sks2701 

Make sure to replace all % values where you are representing a number e.g.

 

if [Net sales growth] < 0.01
else if [Net sales growth] >= 0.26

 

 etc.

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


View solution in original post

4 REPLIES 4
PhilipTreacy
Super User
Super User

Hi @sks2701 

Make sure to replace all % values where you are representing a number e.g.

 

if [Net sales growth] < 0.01
else if [Net sales growth] >= 0.26

 

 etc.

Phil


If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


THANK YOU! It helped 🙂

AlB
Super User
Super User

Hi @sks2701 

It must be the % character. You can't use it like that. Instead of 1% use the number: 1/100 or  0.01. Same for all other % instances in the code

Please mark the question solved when done and consider giving a thumbs up if posts are helpful.

Contact me privately for support with any larger-scale BI needs, tutoring, etc.

Cheers 

SU18_powerbi_badge

thank you !

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors