power query dates

[rjmdc]

hi
i removed the variables and instead used real dates
i still get a null
whats wrong with the equation?

= Table.AddColumn(#"Changed Type4", BudgetYear2, each if BudgetYear1 <> null then Date.AddYears (Record.Field(_, BudgetYear1),1) 
else if [Adjusted Budget Approval]<> null and #date(2022,6,1) >= #date(2022,1,1) and [Adjusted Budget Approval] <= #date(2022,12,31) then [Adjusted Budget Approval]
else null)

 

[jdellasala]

For starters, to add a simple column, the syntax is

= Table.AddColumn(#"Changed Type4", "BudgetYear2", each if [BudgetYear1] <> null then Date.AddYears( [BudgetYear1], 1) else null)

Note that BudgetYear2 - the name of the new column is in quotes, and the referenced column BudgetYear1 is within square brackets.
Having a more complete table might help, but there are others in the forum much better at M than I am!
If you post a small sample table, be sure to use XL2BB.