Forum Discussion
How make IF returns value from column
Hello!
I'm newbie at Power BI and Im struggling to solve a simple question.
I did a search on forum but there is so much information and i didn't find what i need especifically.
So let's go.
My trouble is with the "IF"
What I need to do is
IF(ColumnA = 0, "nok", *return the value in ColumnA*)
For exemple
| ColumnA | Column with IF |
| 0 | nok |
| 1 | 1 |
| 0 | nok |
| 1 | 1 |
The columnA is a float type.
I tried:
IF('Table'[ColumnA] = 0, "nok", SUM('Table'[ColumnA]))
IF('Table'[ColumnA] = 0, "nok", ALL('Table'[ColumnA]))
IF('Table'[ColumnA] = 0, "nok", VALUE('Table'[ColumnA]))
...
but i got the error:
Expressions that generate variable data types cannot be used to define calculated columns.
Anybody can help me, please? 😞
Hi, Anonymous
In my opinion, I think the error is because of the data type.
Please try to change the data type of DDL Pending QTY to TEXT, and try the below for creating a new column.
Coluna = IF('Base SAP'[DDL Pending Qty] = "0", "NOK", 'Base SAP'[DDL Pending Qty])Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
10 Replies
- Jihwan_Kim
Super User
Hi, Anonymous
If you are trying to create a new column, please try the below.
new column =
IF('Table'[ColumnA] = 0, "nok", 'Table'[ColumnA])
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
- Jihwan_Kim
Hi, Anonymous
Thank you for your feedback.
If it is OK with you, please share your sample pbix file's link here, then I can try to look into it to come up with a more accurate solution.
Thank you.