Forum Discussion
Power Query - Add Column which is global minimum of another column
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 | ... |
Hi Anonymous
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))
1 Reply
Hi Anonymous
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))