Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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? 😞
Solved! Go to Solution.
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.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
It didnt work 😞
i got the message:
Expressions that generate variable data types cannot be used to define calculated columns.
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.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Sure!
But you'll need some explanations.
I created a generic table to explain my issue.
On my pbix file, i have to do the IF with the column "DDL Pending Qty", so:
Hi,
Thank you for your message.
I think you shared a link address of your PBI service website, which I cannot access.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Sorry 😞
How can i share my sample pbix file's link?
Sorry for this kind of question
Hi, @Anonymous
You can save your sample pbix file in OneDrive or GoogleDrive, and you can share the link here.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Thank you
Heres the link:
https://drive.google.com/drive/folders/1HcMUlF0eddyPO6LA6XLgRR_mSwlsonSA?usp=sharing
Note: The column "DDL Pending Qty" is from the file "Base SAP"
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.
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
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |