Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello.
I have the results of a survey in which the answers are “yes” and “no”. From Power query with the conditional column function I transformed the answers “Yes” to 1 and “No” to 0. The problem I have is that for question 3 the logic is the other way around: ‘Yes’ would have to be 0 and “No” is worth 1. I have tried filtering the values of Question 3 but I have not succeeded. I would like to know if this can be done from Power Query or do the conditional column creation as a DAX.
I leave a screenshot with the result I get with the Conditional Column and another column with "what I want".
Thanks for your comments.
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
= Table.AddColumn(Source, "Expected result", each if [Questions] = "Question 3" then if [Answer] = "No" then 1 else 0 else if [Answer] = "Yes" then 1 else 0)
Hi,
Please check the below picture and the attached pbix file.
= Table.AddColumn(Source, "Expected result", each if [Questions] = "Question 3" then if [Answer] = "No" then 1 else 0 else if [Answer] = "Yes" then 1 else 0)
@Jihwan_Kim's solution is already in Power Query.
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
72 | |
38 | |
31 | |
27 |
User | Count |
---|---|
92 | |
50 | |
44 | |
40 | |
35 |