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 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?
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
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
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
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.
@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 🙂
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |