Forum Discussion
Helper IIFormat for multiple if statements
Hi,
I was unable to find an example of this somewhere yesterday, hope some can help.
Have a field which has #'s in it, all the way thru 9999. Depending on the # of the field, I want to have a new field with a word in it.
So like this:
numberfield = 3103, 4501, 5700, 8254.
In new field I want to have the words:
newfield = lowest,midrange,midrange,highest.
I have
vnicholl use double quotes:
Column = IF('table'[numberfield]<4400,"lowest",IF✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.
1 Reply
- parry2k
Super User
vnicholl use double quotes:
Column = IF('table'[numberfield]<4400,"lowest",IF✨ Follow us on LinkedIn and to our YouTube channel
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.