Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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 ... ...
Need Help
  • mlsx4's avatar
    mlsx4
    2 years ago

    Hi Anonymous 

    = Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))
mlsx4's avatar
mlsx4
Memorable Member
2 years ago

Hi Anonymous 

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