Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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 | ... |
Solved! Go to Solution.
Hi @Anonymous
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))
Hi @Anonymous
= Table.AddColumn(#"PreviousStepName", "Min_response_timestamp", each List.Min(Table[response_timestamp]))