Power BI Custom Column with Nested IF Statement

Molly Glowacki

Hello, I created the following custom column and I'm getting errors where the referenced date value is null. How can I handle the null values in Power Query?

if Date.Month([Prospect Opportunity Date Asked]) <= 6
then Date.Year([Prospect Opportunity Date Asked])
else if Date.Month([Prospect Opportunity Date Asked]) >= 7
then Date.Year([Prospect Opportunity Date Asked]) + 1
else null

Alex Wong

@Molly Glowacki
= Table.AddColumn(#"Removed Other Columns", "Custom", each if [ask_date] = null then null else if Date.Month([ask_date]) <= 6 then Date.Year([ask_date]) else Date.Year([ask_date])+1)

Molly Glowacki

@Alex Wong thank you! That worked.