Power Query

[BishwaR]

I want to write a logic in power query.

If the Dispatched Year = current year then null else Dispatched Year.

I created a custome column like IF [Dispatched Year] = Date.Year(DateYear.LocalNow()) then null else [Dispatched Year] But it does not work.

Thanks

[mahoneypat]

Note that M is case sensitive and your localnow function was wrong.

if [Dispatched Year] = Date.Year(Date.From(DateTime.LocalNow())) then null else [Dispatched Year] 

Pat

[BishwaR]

It is returning all nulls even for Dispatched Year 2021