Forum Discussion
Automatically update a column when a value in another column exist more than once
Dear all I have a log table to record each action ("Action" column), when it happen ("Log_Time" column), and its meaning ("Process" column). My target is to automatically update the "Proce...
sorry, somehow forgot to paste in the code for the calculated column:
Column = VAR _action_A_max = CALCULATE ( MAX ( 'Table'[Log_time] ), FILTER ( ALL ( 'Table' ), 'Table'[Process] = "Action A" ) ) RETURN IF ( 'Table'[Log_time] >= _action_A_max, CONCATENATE ( "Start of Process ", RIGHT ( 'Table'[Process], 1 ) ), BLANK () )
Thanks Sturla! It works!