Power BI Custom Column with Nested IF Statement

Molly Glowacki · April 15

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

f4c2d4d4077fc3b3df9dd0eebcf8d7ac-huge-im

Alex Wong · April 16

@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)

3e08d05f26e51209da61205a1c96c1c8-huge-im

Molly Glowacki · April 16

@Alex Wong thank you! That worked.

Power BI Custom Column with Nested IF Statement

Comments

Categories