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.
Hi,
I’m new to Power BI and am trying to create a new column in Power Query. To explain I'm trying to write a condition if Quarter = Q1-2022 and Q3_Q3B is not blank then return 1 else return null for all other cases.
My current syntax is:
= if [Quarter]="Q1-2022" and [Q3_Q3B] <> null then 1 else null
Example data
Quarter | Q3_Q3B | Desired column output | Current incorrect output |
Q1-2022 | Agree Strongly | 1 | 1 |
Q1-2022 | Agree | 1 | 1 |
Q1-2022 | Neither | 1 | 1 |
Q1-2022 | Disagree | 1 | 1 |
Q1-2022 | Strongly Disagree | 1 | 1 |
Q1-2022 | Not sure | 1 | 1 |
Q1-2022 | null | 1 | |
Q1-2022 | null | 1 | |
Q2-2022 | Agree | null | null |
Q2-2022 | Neither | null | null |
I don’t have a syntax error but I don’t quite get the desired output. The 3rd column is what I want to achieve the 4th column is the current output I get.
I'd appreciate any help
Jazz
Solved! Go to Solution.
Hi,
In the column Q3_Q3B there is no null value. In your formula's if condition use "" instead of null.
Artur
Hi,
In the column Q3_Q3B there is no null value. In your formula's if condition use "" instead of null.
Artur
Thank you.
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.