Forum Discussion
Conditional Column : If then not working
Anonymous
It could be due to additional whitespace in the cell.
Apply the trim function and then create the conditional column.
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂
I used TRIM and then created the conditional Column , still same results. Only returns else value.
Hi Anonymous
Yes I am new to the programining and practicing power bi with conditional column. I create seperate Table for Combination and Description , linked it to main table. I am still not getting answer
Thanks
Anonymous
You can achieve this by implementing a calculated column using simple nested if condition.
Another method: Grouping https://docs.microsoft.com/en-us/power-bi/desktop-grouping-and-binning
Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂Hi Anonymous ,
Maybe it is caused by the order of conditions. Please move them up and down to have a try.
Here is a blog about conditional column. Hope it can help you.
Conditional Column in Power BI using Power Query; You can do anything!
Hi Anonymous ,
Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from the thread.
I used TRIM and then created the conditional column , it's still the same results. It returns only else value.
Hello @Lewis-H
Yes, I'm new to programming and practicing power bi with conditional column. I create a separate table for Join and Description, linked to the main table. I'm still not getting a response
Thank you
