Custom Column

[JRana]

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

[artpil · Accepted solution]

Hi,

In the column Q3_Q3B there is no null value. In your formula's if condition use "" instead of null.

Artur

[JRana]

Thank you.