Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I was trying to create a Conditional Colum expecting that if the first condition is TRUE than all the Else Ifs would be ignored but this does not seem to be happening.
Basically, I want to set it so that if the value on L1Tag Column equals "Transfer" then the value is set to Transfer and it stops right there.
See Conditional Statement below and resulting table.
What am I doing wrong?
Thank you
J
Solved! Go to Solution.
@jagostinhoCT
Your conditions are based two fields and it will continue to evaluate the subsequent levels as based on true/false. You can add a custom column and use OR/AND combination to achieve this as well.
It seems you have put "Transfer" instead of "Transfers", in Value section, missing last s, correct and try, it shoudl work.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
Hi @jagostinhoCT,
You forgot an "s" in Transfers and that's why it is not working properly for you.
I tried the same conditional column as you and it worked for me. Please find below the screenshot.
Also, I observed that you are forgetting to add a condition if the LT1Tag is not "Transfers" and the Amount is 0 i.e. the first "Else if" condition in my screenshot --> "Greater than or equal to 0". I think you should consider that also and incorporate in the column 🙂
Regards
Simran Tuli
@jagostinhoCT That's exactly how conditional statements work. I think you forgot an "s" in Transfers
your column says "Transfers" not "Transfer"
Change your conditional to Contains "Transfer" or is equal to "Transfers" this will sort your issue out.
@jagostinhoCT
Your conditions are based two fields and it will continue to evaluate the subsequent levels as based on true/false. You can add a custom column and use OR/AND combination to achieve this as well.
It seems you have put "Transfer" instead of "Transfers", in Value section, missing last s, correct and try, it shoudl work.
________________________
Did I answer your question? Mark this post as a solution, this will help others!.
Click on the Thumbs-Up icon on the right if you like this reply 🙂
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
of course...
"Transfers" not "Transfer"
Such a rookie mistake. 😞
Sincere apologies and thank you very much.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |