Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I have a column called 'Sentiment' with numbers between 0 and 1.
I want to add a new column based on the condition as follows:
[Sentiment] <0.5 then "Negative"
[Sentiment] =0.5 then "Neutral"
[Sentiment] >0.5 then "Positive"
I know you can add a conditional column in PowerBI.
But at the beginning I wrote a query like this:
If [Sentiment]< 0.5 then "Negative"
else
If [Sentiment] = 0.5 then "Neutral"
else
If [sentiment] >0.5 then "Positive"
else NULL
There is an error message says Token Eof expected.
What should be the correct query for this?
Solved! Go to Solution.
@Iyao - Don't capitalize your if's Also, I don't think you want NULL capitalized either. M is picky about these things.
@Iyao - Don't capitalize your if's Also, I don't think you want NULL capitalized either. M is picky about these things.
It works. Thank you
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |