Forum Discussion
Conditional Column : If then not working
Hello ,
I am doing very simple If then statement using Condition column and only getting others results for all the rows. Both the columns have dataset type "Text".
Does anyone why it is happening?
7 Replies
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 🙂
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
In Excel, IF is a core function, it’s one of the first ones we learn. Last week, we looked at Functions in Power Query, but we didn’t cover a Power Query version of the IF function. Surely there is one… right? …well, kind of.
To use if logic in Power Query, we need a more programming based methodology rather than a function based methodology we find in Excel. If you’ve ever programmed VBA or other languages, you will be familiar with this approach. However, if you’re coming from a purely Excel world this may be new to you.
There are two options:
Using the conditional column feature for basic if logic
Writing M code for more advanced if logic.Admin
