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
