I have a column that contains dates, but some are left blank or have a 0. When the date is 0 or blank, I want it to display the current date plus 180 days. I first selected the column and replaced value of blank or 0 with 19010101, then built a custom column
if [columnname] = 19010101 then Date.AddDays(DateTime.LocalNow, 180) else [columnname]
but this is not working. Any suggestions?