Power Query - Add Column which is global minimum of another column

[Anonymous]

Hi,

I have the the following data :

response_timestamp	id	status	infos
26/10/2023 4:30 PM	1	active	...
26/10/2023 4:31 PM	2	inactive	...
26/10/2023 4:33 PM	3	active	...

I would like to keep the minimum response_timestamp but can't figure out the M code to do so. I have calculated the minimum with List.min() function but don't know how to assign it to a new column...

The expected result would be : 

response_timestamp	min_response_timestamp	id	status	infos
26/10/2023 4:30 PM	26/10/2023 4:30 PM	1	active	...
26/10/2023 4:31 PM	26/10/2023 4:30 PM	2	inactive	...
26/10/2023 4:33 PM	26/10/2023 4:30 PM	3	active	...

[mlsx4 · Accepted solution]

Hi @Anonymous 

= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))