Conditional replace values

[Anonymous]

Hi Community,

My data set has data quality issues. In the follwoing sample data set, how can I replace end_date 1/01/1900 with end_date from the row where E_key ,Client_key & program are the same but val = 3 & comment is not null:

Many thanks!

[amitchandak · Accepted solution]

@Anonymous , a new column

New column =

var _1 = maxx(filter(Table, [E_key] = earlier([E_key) && [End_date] >date(1900,01,01) ), [End Date] )

return

if( [End_date] = date(1900,01,01), _1, [End_date])