Forum Discussion
osinquinvdm
Advocate II
Advocate IIWe cannot apply field access to the type Null
I need to set a date for some type of data. Namely when [Nature]="Information", the "End Date" is null and I need to replace that null value by whatever date is in the “Start Date” column. ...
With Table.TransformColumns, it is not possible to reference other columns.
Instead, you can add a column with the fixed empty date, then delete the original End Date and rename the new column to End Date (and optionally move it to the original location of End Date).
MarcelBeug
Community Champion
Community ChampionWith Table.TransformColumns, it is not possible to reference other columns.
Instead, you can add a column with the fixed empty date, then delete the original End Date and rename the new column to End Date (and optionally move it to the original location of End Date).